Truncate Table in a PL/SQL Block

From: Huijbrechts Rolf <huybrecr_at_realsoftware.be>
Date: 1996/10/19
Message-ID: <3268FFDF.23BA_at_realsoftware.be>#1/1

Hi,

I need to delete all rows in a fast way in a PL/SQL block ? It is an all-or-nothing operation so the changes should not be registered in the rollback segments.

I tried to issue a TRUNCATE TABLE but this is not supported in a PL/SQL block for Oracle V7.2.

How can help me out on this one ?

Much appriciated,

Rolf Huijbrechts
REAL SOFTWARE
All opinions expressed are mine and not those of my employer.

email : huybrecr_at_realsoftware.be or 101505.533_at_compuserve.com website: http://www.realsoftware.be/

Received on Sat Oct 19 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Huijbrechts Rolf: "Change tablespace of an index"
Previous message: John Parrott: "How many open Max Open Cursors?"
Next in thread: Robert Desatnik: "RE: Truncate Table in a PL/SQL Block"
Reply: Dave Mausner: "Re: Truncate Table in a PL/SQL Block"
Reply: Srinivasa Rao Vaikuntam: "Re: Truncate Table in a PL/SQL Block"
Maybe reply: Huijbrechts Rolf: "Re: Truncate Table in a PL/SQL Block"
Reply: Robert Desatnik: "RE: Truncate Table in a PL/SQL Block"
Maybe reply: michael j miller: "Re: Truncate Table in a PL/SQL Block"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message