Re: PL/SQL to truncate a table
From: James A. Williams <willjamu_at_mindspring.com>
Date: Sat, 16 Dec 2000 17:52:47 GMT
Message-ID: <3a3babcf.23031682_at_news.mindspring.com>
Date: Sat, 16 Dec 2000 17:52:47 GMT
Message-ID: <3a3babcf.23031682_at_news.mindspring.com>
willjamu_at_mindspring.com (James A. Williams) wrote:
Sounds like a use for the DBMS_SQL package or Native dynamic SQL.
>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 - 18:52:47 CET