I have requirement to create table using EXECUTE IMMEDIATE in package. However table name needs to be dynamic using sysdate on daily basis.
e.g XXAA_TESTTBL_08272017 - Aug 27th
XXAA_TESTTBL_08282017 - Aug 28th
Below Declare block creates table, how can i make the table name dynamic using SYSDATE.
DECLARE
sqlstring VARCHAR2(2000);
BEGIN
EXECUTE IMMEDIATE
'CREATE TABLE XXAA_TESTTBL_1 AS SELECT * FROM AR.HZ_PARTIES WHERE 1=2'
;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error: '||SQLERRM);
END;