Deleting all rows from a table

From: Bharat Kumar <bharat_at_allegra.tempo.att.com>
Date: 1996/06/14
Message-ID: <4prtk1$j4o_at_big.info.att.com>#1/1

I'm writing a PL/SQL procedure that requires the use of a couple of temporary tables. Currently, I've created those temp. tables outside the procedure, and inside the procedure, after I'm done with the main work, I delete all the rows in those temp tables (required for subsequent invocations of the procedure). I would like to use something similar to a "truncate" command, since the "delete from temp_table" command takes a long time. However, I can't put the truncate command directly into the procedure. Any suggestions?

Here's the psuedocode for the procedure:

   procedure blah

	insert into temp_table (subquery...)
        ... select/project/join queries on the temp_table
        delete from temp_table;

   end blah;

Please post replies to this newsgroup.

Thanks,
-Bharat

---

Disclamer: My opinions are mine alone, and no one else can have them. Received on Fri Jun 14 1996 - 00:00:00 CEST