kindly help for this dynamic creation of table using execute immediate
DECLARE
ddl_qry VARCHAR2 (150);
tab_name varchar2(100):='PART_TABLE';
BEGIN
ddl_qry := 'CREATE TABLE T_DEF_VAL AS SELECT 'ALTER TABLE '
||TABLE_NAME
|| ' MODIFY '
|| COLUMN_NAME
||' DEFAULT 0 ' AS DEF_VAL
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = '||tab_name ||
AND data_default IS NOT NULL'';
EXECUTE IMMEDIATE ddl_qry;
END;