Re: 'temp' oracle tables

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/04/14
Message-ID: <3351E2F9.B50D868C@pmcgettigan.demon.co.uk>#1/1

Gopal wrote:

> 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

Take some advice: Get some Oracle consultancy. It sounds as if your 'complex app.' will end up quite a mess otherwise.

Steve Phelan. Received on Mon Apr 14 1997 - 00:00:00 CDT