Temporary tables inside procedure

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 28 Jul 2006 12:04:13 -0400

Hi,

We have to port sql server procedures to pl/sql, In some SQL Server procedures 
the temp table is created inside the procedure and populated with data and then 
truncated at the end, in oracle we can create global temporary tables outside 
procedure and use them but we are wondering if there is any other better way to 
do this in oracle.
--
//www.freelists.org/webpage/oracle-l


Other related posts: