Temporary Storage [message #20045] |
Fri, 26 April 2002 05:15 |
LI810
Messages: 25 Registered: February 2002
|
Junior Member |
|
|
Please help . How I can store intermidiate result in the stored procedure that has a pretty compex buisness logic? Required to have several intermediate result , update them etc .
I came from Sybase ,where the solution are temporary tables.
What can be done in Oracle ?
|
|
|
|
Re: Temporary Storage [message #20055 is a reply to message #20045] |
Fri, 26 April 2002 12:35 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
I don't know what a Sybase temporary table is exaclty but there is also a Oracle temporary table:
CREATE GLOBAL TEMPORARY TABLE ...
Have a look in the documentation to find out if it's what you need.
|
|
|
Re: Temporary Storage [message #20066 is a reply to message #20045] |
Sat, 27 April 2002 04:25 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
Hi
In oracle also we can use Temp tables which has exactly the same functionality as in the case of sybase.
In sybase u create & drop temp table everytime in the begining & end of transaction while in oracle u have to create only once and in the proc/funct u can populate those temp table.
Note: If u r performing multiple independent transactions on the temp table then before popoulating these tables delete/truncate these tables.
Creation of temp table is as follows:
create or replace global temporary table tname
on commit preserve rows
as(.......
.........)
|
|
|