Re: Help! Question on PL/SQL

Sorry, addition to that statment Oracle prior to 8i doesn't support temporary tables

Regards

Oracle doesn't support the temporary tables identified in your procedure by the #

Using a SELECT ... INTO ... within Oracle is the method of populating a variable, the same as SELECT @var = expr in SQL Server

If these are multiple row selects, you may consider either a cursor or a PL/SQL Table (Virtual table with a BINARY_INTEGER Primary key and value)

Of course if the "Temporary" tables were created first as normal tables and then populated within the query you would use the standard INSERT INTO table AS SELECT ... FROM ... WHERE

Hope this help a little

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com  

-----Original Message-----
From: Dana Jian [mailto:djian_at_trasa.com] Posted At: Thursday, January 20, 2000 3:47 PM Posted To: server
Conversation: Help! Question on PL/SQL
Subject: Help! Question on PL/SQL

Hi,

I'm converting one procedure from SQL server to Oracle procedure.

Here's the simplified statements in the SQL proc,

SELECT ... INTO #temp1 FROM....WHERE..

SELECT ... INTO #temp2 FROM... WHERE

SELECT ... FROM #temp1, #temp2 , .... WHERE ...

How to do this in Oracle PL/SQL?

Any comments/help will be highly appreciated!!

Dana
djian_at_trasa.com Received on Fri Jan 21 2000 - 06:01:15 CST