Re: Truncate
Date: 1996/11/22
Message-ID: <574ctc$j85_at_sjx-ixn3.ix.netcom.com>#1/1
The only way, truncate can be used conditionally is thru PL/SQL.
A combination of the condition and the DBMS_SQL package will do it.
One unintended advantage is that you can use one procedure to truncate
any table.
Hope this helps.
In <32914BC9.6EEB_at_qrcsun.qrc.org> "Lun Wing San (Oracle)"
<wslun_at_qrcsun.qrc.org> writes:
>
>Arlie E. Hammons wrote:
>>
>> Does anyone know of a conditional truncate? I am
>> using Oracle V 7.3.2.2.
>
> Truncate is a fast deletion of ALL rows. It seems that no condition
can be specified.
>
> Related Topics: Constraint, Trigger
>
>---
>Name : Lun Wing San
>Title : Oracle Application Developer of Hong Kong Productivity
Council
> Oracle Database Administrator and System Administrator of QRC
>Phone : (852)27885841
Received on Fri Nov 22 1996 - 00:00:00 CET