|
-
In 8.0 you can use procedure exec_ddl_statement in package dbms_utility for ddl statements:
procedure create_table (table_name in varchar2,column1 in varchar2,column2 in varchar2)
as
begin
dbms_utility.exec_ddl_statement('create table '||table_name||' ('||column1|| ' varchar2(10), '|| column2 ||' varchar2(10))');
end;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|