Re: using truncate in oracle7 procedures

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/20
Message-ID: <32BB7AA0.B91@qrcsun.qrc.org>#1/1

heath wrote:
>
> can TRUNCATE TABLE be used in database procedures? i need to regularly
> remove all rows in a quite large table and recreate the table. DELETE
> works but takes a long time ... when i put TRUNCATE in the procedure,
> compilation fails.

You can use dynamic SQL to solve your problem. Please refer to DBMS_SQL for detail.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Fri Dec 20 1996 - 00:00:00 CST