Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> using truncate in oracle7 procedures

using truncate in oracle7 procedures

From: heath <heaths_at_powerup.com.au>
Date: 1996/12/17
Message-ID: <01bbebcb$6d5fbd60$8e5312cb@7636hvs40626>#1/1 







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.




thank, ben
Received on Tue Dec 17 1996 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US