Re: PL/SQL to truncate a table
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 16 Dec 2000 14:38:51 +0100
Message-ID: <91gsub$46gtj$1_at_ID-62141.news.dfncis.de>
Date: Sat, 16 Dec 2000 14:38:51 +0100
Message-ID: <91gsub$46gtj$1_at_ID-62141.news.dfncis.de>
It is
[Quoted] Use dbms_sql (7.3, 8.0) or execute immediate (8i+) to address your need.
Hth,
[Quoted] Sybrand Bakker, Oracle DBA
"James A. Williams" <willjamu_at_mindspring.com> wrote in message
news:3a3b579d.1474103_at_news.mindspring.com...
> I need to clear out a staging table weekly prior to an application
> coming up. I know how to issue DML. Is truncate table considered DDL..
>
>
> Logic:
>
> Insert into work select * from xxxx;
>
> if rc =0
> then
> do
> truncate table
> end
> else
> do
> Say 'Insert did not work'
> end
>
> exit
Received on Sat Dec 16 2000 - 14:38:51 CET