Oracle存储过程中执行DDL操作
2007-04-13 15:48 flyingfish 阅读(2074) 评论(0) 编辑 收藏 举报Create Or Replace Procedure My_Proc As
Sqlddl Varchar2(1000);
Begin
Sqlddl := 'create table MyTable(ID Number(5), Name Varchar2(20))';
Dbms_Output.Put_Line(Sqlddl);
Execute Immediate Sqlddl;
End;