create or replace procedure pr_DelTable ( tablename in varchar2(50) ) as strsql varchar2(1000); begin
strsql := 'delete from '||tablename; execute immediate strsql; end pr_DelTable;
create or replace procedure pr_DelTable ( tablename in varchar2 ) as strsql varchar2(1000); begin strsql := 'delete from '||tablename; execute immediate strsql; end;
(
tablename in varchar2(50)
)
as
strsql varchar2(1000);
begin
strsql := 'delete from '||tablename;
execute immediate strsql;
end pr_DelTable;
(
tablename in varchar2
)
as
strsql varchar2(1000);
begin
strsql := 'delete from '||tablename;
execute immediate strsql;
end;