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 -> Re: Truncate Table in PL/SQL

Re: Truncate Table in PL/SQL

From: dgmenace <dgmenace_at_netscape.net>
Date: Fri, 12 Nov 1999 14:23:45 -0800
Message-ID: <382C9371.AFEB67BA@netscape.net> 





TRUNCATE is a SQL*Plus command that can not be executed in PL/SQL



Chua Boon Yiang wrote:



> Hi


>


> can i do a "truncate table T1" in a PL/SQL block ?


> as i need to manipulate a temp table very often, w/o the ability to do a


> truncate table will have abit efficiency problem.


>


> Thanks


> Boon Yiang



Received on Fri Nov 12 1999 - 16:23:45 CST












Original text of this message













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