Re: Problem with temporary tables

Bobby V. wrote:
>
> In another application with SQL Server as back end we were able to use
> temporary tables in stored procedures like:
>
> create table #temp (proj_no char(10), fees decimal(15,2));
> Q1: How to create any temporary table in STORED PROCEDURE in Oracle
>
> insert into #temp (proj_no, code, fees)
> select proj_no, sum(amount*multiplier) from project
> group by proj_no, ;
>
> Above statement would do a fast transfer and massage of data into
> temporary table (cursor specific,
> no logging etc.), and would be easily drop once stored procedure is
> finished.
>
> Could we do something like this on Oracle?

Bobby,

You can create pl/sql table-like arrays to simulate temporary tables. A lot depends on the version of Oracle you are using. Check your documentation for creating pl/sql tables and records

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.