sorry,
动态删除一个表的pl/sql script:
create or replace addtable(tablename varchar2(50))
as
v_sql varchar2(1000);
begin
v_sql:='delete from '||tablename ||' ;
execute immediate v_sql;
end
;
动态删除一个表的pl/sql script:
create or replace addtable(tablename varchar2(50))
as
v_sql varchar2(1000);
begin
v_sql:='delete from '||tablename ||' ;
execute immediate v_sql;
end
;
grant create table to current_user就可以了.