'temp' oracle tables

From: Gopal <gopal_at_astro.temple.edu>
Date: 1997/04/11
Message-ID: <5im1cc$dnh@cronkite.ocis.temple.edu>#1/1

Hi Guys,

We are in the middle of porting a rather complex SQL Server app. to Oracle 7.3.x.

I confess at the outset that I am new to Oracle.

I would like to find out about how to create and user 'temp' tables in Oracle in a manner similar to SQL Server. In SQL Server it is possible to create temp tables in a stored procedure and this table is only visible to that procedure and dies after the procedure completes.

Thank You

Regards

Gopal
please email to gopal_at_astro.ocis.temple.edu Received on Fri Apr 11 1997 - 00:00:00 CDT