Re: How to create temp table in memory in Oracle

From: Brad Worsfold <bworsfold_at_vic.lgs.ca>
Date: 1997/07/22
Message-ID: <01bc96d7$3a9b42c0$0faf22cf@cerulean>#1/1

You can also create a table in PL/SQL in memory.

It has syntax of

TYPE new_type IS TABLE OF {type | table.column%TYPE} INDEX BY BINARY_INTEGER; However, this will not work in Oracle Forms. This will work if it is part of a package
in the oracle database.

Hope this helped!

Brad

ChanderR_at_KochInd.com wrote in article <869157958.20004_at_dejanews.com>...
> Hi;
>
> I am trying to find out the way to create temp table in memory in oracle
> as you do in Sybase or MS SQL server (eg. create table #temp_table). This
> table will stay in memory, will go away at the end of user transaction.
>
> Any help will be greatly appreciated.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Tue Jul 22 1997 - 00:00:00 CDT