- Create a temporary table v_dynamic_sql: = 'create global temporary table' || 'test' || 'on commit preserve rows as select * from' || 'all_Objects where 1 = 2'; execute immediate v_dynamic_sql;