Re: Truncate Table in PL/SQL

From: <markp7832_at_my-deja.com>
Date: Thu, 11 Nov 1999 15:03:06 GMT
Message-ID: <80elr7$s4a$1@nnrp1.deja.com>

In article <80d6qh$820$1_at_newton.pacific.net.sg>, "Chua Boon Yiang" <chuaby_at_hotmail.com> 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
>

Truncate is a DDL statment and DDL is not directly supported by pl/sql prior to 8i.

It is my understanding with 8i you can code a truncate with the execute immediate pl/sql statement.

For ver 8 and below you can issue the command through the dbms_sql package.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 09:03:06 CST