Re: Help! Question on PL/SQL

From: bejones <bejones_at_cyberzone.net>
Date: Thu, 20 Jan 2000 19:43:50 -0500
Message-ID: <3887b98a@news.cyberzone.net>

In you example you create temp1 and temp2 so that the third query can join the two temp tables. This type of operation is done in SQL SERVER for performance reason and is not necessary in Oracle.

This is a habit you must break now that you are using a real database.

Dana Jian wrote in message <38872dc8$0$89858_at_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 - 18:43:50 CST