Re: Problem with temporary tables

The answer is "NO". Oracle doesn't support temporary tables. I wish they did.

Murali

-- 
Murali Kazhipurath
Technical Consultant
Kaustubam (Database and Internet Solutions Provider)
murali_at_jps.net
Phone # (916) 773 1918

Bobby V. <bobbvy_at_ussinc.com> wrote in article <329F4FEA.1C92_at_ussinc.com>...


> 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?

>