PL/SQL to truncate a table
From: James A. Williams <willjamu_at_mindspring.com>
Date: Sat, 16 Dec 2000 12:02:28 GMT
Message-ID: <3a3b579d.1474103_at_news.mindspring.com>
Date: Sat, 16 Dec 2000 12:02:28 GMT
Message-ID: <3a3b579d.1474103_at_news.mindspring.com>
[Quoted] [Quoted] I need to clear out a staging table weekly prior to an application [Quoted] coming up. I know how to issue DML. Is truncate table considered DDL..
Logic:
[Quoted] 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 - 13:02:28 CET