Table truncation

Posted by 'Bobby Kenji' on September 08, 2001 at 04:39:10 EST:

How can I write a pl/sql IF statement that truncates 1 table if another 1 is empty:

I want to:
If count(*) on emp >0
then truncate emp1;

Has someone the code exampl e for this?

Name:
E-Mail:
Subject:
Message: : How can I write a pl/sql IF statement that truncates 1 table if another 1 is empty: : I want to: : If count(*) on emp >0 : then truncate emp1; : Has someone the code exampl e for this?