Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE TEMPORARY TABLE USING EXECUTE IMMEDIATE

771751Jun 11 2012 — edited Jun 12 2012
Hi All,
i have a question,
how can i create a temporary table using EXECUTE IMMEDIATE ??

Like:

CREATE GLOBAL TEMPORARY table new_table as (Select * from old_table);

Thanks,

Edited by: xDeviates on Jun 11, 2012 3:13 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2012
Added on Jun 11 2012
11 comments
13,290 views