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

Home -> Community -> Usenet -> c.d.o.server -> Re: TRUNCATE in PL/SQL

Re: TRUNCATE in PL/SQL

From: Jarek Palka <jarek_at_kamsoft.com.pl>
Date: 2000/04/10
Message-ID: <38F19502.39AF4246@kamsoft.com.pl>#1/1

> Why can't I compile the TRUNCATE statement in pl/sql code? Is there a
> better way? Thanks,

dbms_utility.exec_ddl_statement('TRUNCATE TABLE abc DROP STORAGE');

-- 
____________________________________________________________
Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
tel. (+48 32) 209-07-05, fax 209-07-15    POLAND
Received on Mon Apr 10 2000 - 00:00:00 CDT

Original text of this message

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