OraFAQ Forum: SQL & PL/SQL » how do i issue the truncate table tab1 statement within a plsql procedure

Home » SQL & PL/SQL » SQL & PL/SQL » how do i issue the truncate table tab1 statement within a plsql procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how do i issue the truncate table tab1 statement within a plsql procedure [message #36604]

Thu, 06 December 2001 01:08

krs
Messages: 9
Registered: November 2001

Junior Member

Hi,
How can i issue the
" truncate table tab1 drop storage " statement inside a plsql procedure.

Thanks
Srini

----------------------------------------------------------------------

Report message to a moderator

Re: how do i issue the truncate table tab1 statement within a plsql procedure [message #36606 is a reply to message #36604]

Thu, 06 December 2001 03:39

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

execute immediate 'truncate table tab1';

remember truncate table command issues commit

----------------------------------------------------------------------

Report message to a moderator

Re: how do i issue the truncate table tab1 statement within a plsql procedure [message #36628 is a reply to message #36604]

Thu, 06 December 2001 18:39

Satish Shrikhande
Messages: 167
Registered: October 2001

Senior Member

create or replace procedure a12 as
a varchar2(100):='T';
begin
execute immediate 'truncate table '||a;
end;

here define a variable which will hold the name of table .

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	adding table to memory?
Next Topic:	Truncating a Table from SP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 01:07:59 CDT 2025