Re: Oracle 8i and temporary tables

From: <morar2000_at_my-deja.com>
Date: Wed, 16 Aug 2000 17:37:26 GMT
Message-ID: <8nejgj$8oi$1@nnrp1.deja.com>

In article <399AC342.1A463107_at_Unforgetable.com>, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> morar2000_at_my-deja.com wrote:
> >
> > I am migrating a SQL Server database to ORACLE 8i.
> > The SQL server database is heavily using stored procedures and
temporary
> > tables.
> > Any idea on how to implement this in ORACLE 8i nice and easy ?
> >
> > Thanks.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Both stored procedures and temporary tables are available in 8i.
>

The difference is that a SQL server stored procedure alows me to return a result set, while an Oracle procedure does not.

The sql server procedures have a last stament somethyng like SELECT * FROM #Temp1.
Any more suggestions ?
Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 16 2000 - 12:37:26 CDT