Creating Table dynamically in Oracle Procedure
Oracle | Nauman | November 5, 2009 at 12:36 amHow can we create a table inside an Oracle procedure.
"CREATE TABLE tableName AS". We cannot execute this statement in procedures because upon creation of procedure it would give syntax error.
We can implement this with the help of EXECUTE IMMEDIATE command and then dynamically create table.
Tags: create table, execute immediate, Oracle, procedurecreate or replace procedure Proc1 as
begin
execute immediate ‘create table NewTable(column1 integer )’;
end ;
Tweet This
Digg This
Save to delicious
Stumble it
RSS Feed