Skip to Main Content

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!

using execute immediate creating a table from another

1028723Jul 28 2013 — edited Jul 28 2013

hi friend i wanted to create a table from a select statement in a pl sql procedure. i am using execute immediate but getting problems with it pls can anyone help me.

here is the query i am using

EXECUTE IMMEDIATE 'CREATE TABLE table_name AS  (SELECT * FROM  a_view   WHERE column_name LIKE '%some_string%');

i need to know if this can be done and if yes how. pls help me its bit urgent too. the schema name is same and the privileges are available to create tables too.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2013
Added on Jul 28 2013
2 comments
423 views