(转)oracle恢复误删除数据,解除锁定的等sql语句
- ???
- 'yyyy-mm-dd?hh24:mi:ss'))??
?
14.存储过程中执行ddl语句:
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;