Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help! Question on PL/SQL

Help! Question on PL/SQL

From: Dana Jian <djian_at_trasa.com>
Date: Thu, 20 Jan 2000 10:46:48 -0500
Message-ID: <38872de9$0$2954@news.choice.net>


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 Thu Jan 20 2000 - 09:46:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US