kaye

• Aug 22nd, 2006

 

yes.use execute immediate.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

 

yes

create procedure truncatetable(tname in varchar2) is

sqlstr varchar2(100);

begin

sqlstr := 'truncate table '||tname;

execute immediate  sqlstr;

end;

Shital Mistry

• Aug 11th, 2012

 

It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.