Problem with temporary tables
From: Bobby V. <bobbvy_at_ussinc.com>
Date: 1996/11/29
Message-ID: <329F4FEA.1C92_at_ussinc.com>#1/1
Date: 1996/11/29
Message-ID: <329F4FEA.1C92_at_ussinc.com>#1/1
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? Received on Fri Nov 29 1996 - 00:00:00 CET