Re: TRUNCATE TABLE in PL/SQL
From: Chakrapani Venkatesan <chakra_at_ix.netcom.com>
Date: 1995/05/25
Message-ID: <3q1uvk$9e6_at_ixnews4.ix.netcom.com>#1/1
Date: 1995/05/25
Message-ID: <3q1uvk$9e6_at_ixnews4.ix.netcom.com>#1/1
In <rmartin.9.0016732B_at_mindspring.com> rmartin_at_mindspring.com (Robert
Martin) writes:
>
>Is it possible to do a TRUNCATE (or something equivalent) from within
a
>PL/SQL program? I'm having to do a lot of DELETE <table_name>;
COMMIT; on
>large tables and it is extremely slow compared to TRUNCATE.
Check out the standard package supplied with Oracle called DBMS_SQL.
Chakra. Received on Thu May 25 1995 - 00:00:00 CEST