DDL cannot be performed during PLSQL block or stored procedure, you can use dynamic SQL

xiaoxiao2021-03-06  49

- 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;

转载请注明原文地址:https://www.9cbs.com/read-116834.html

New Post(0)