Home » SQL & PL/SQL » SQL & PL/SQL » Temporary table alternative
Temporary table alternative [message #37508] Tue, 12 February 2002 11:10 Go to next message
LI810
Messages: 25
Registered: February 2002
Junior Member
Hello.
Could somebody suggest what is the alternative to use temp table for complicated data processing on the back-end?
I got used to rely a lot on the temp table developing in Sybase . Now , when I started development using Oracle I found that this is not so straightforward technique and looked like better to be avoided.
But , what could be used instead of that if I need to store many intermediate resultsets through the scope of stored procedure.

I was looking up the messages on this message board. Did see , that many people asking same question over and over again. Seemed to be an issue.

Please suggest. Greatly appreciated any help.
Re: Temporary table alternative [message #37510 is a reply to message #37508] Tue, 12 February 2002 11:25 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use pl/sql tables..(arrays)
Re: Temporary table alternative [message #37512 is a reply to message #37510] Tue, 12 February 2002 11:38 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
refer pl/sql language manual

http://technet.oracle.com/doc/server.815/a67842/04_colls.htm#20425
Re: Temporary table alternative [message #37533 is a reply to message #37510] Wed, 13 February 2002 07:24 Go to previous message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
the oracle manual is not clear.
how exactly do i create type of table,
assign values to that and how do i retrieve the values from that..
Previous Topic: SQL Loader stops before end of file
Next Topic: coping one schema to another schema
Goto Forum:
  


Current Time: Thu Apr 25 05:16:13 CDT 2024