Re: Truncate Table in PL/SQL

From: Igor A. Feoktistov <fia_at_ins.dn.ua>
Date: 14 Nov 1999 11:30:10 +0200
Message-ID: <80lvf2$8qn$1@dream.ins.dn.ua>

dgmenace <dgmenace_at_netscape.net> wrote: > TRUNCATE is a SQL*Plus command that can not be executed in PL/SQL No, you are mistake. TRUNCATE is DDL command and can't be executed in PL/SQL

> Chua Boon Yiang wrote:

>> Hi
>>
>> can i do a "truncate table T1" in a PL/SQL block ?
>> as i need to manipulate a temp table very often, w/o the ability to do a
>> truncate table will have abit efficiency problem.
>>
>> Thanks
>> Boon Yiang

-- 
----------------------------
E-mail: fia_at_ins.dn.ua

ICQ: 34433616 Received on Sun Nov 14 1999 - 03:30:10 CST