Oracle-L: which query is ok in different environment

From: Nandu Garg <focussed_at_rediffmail.com>
Date: Wed, 06 Mar 2002 00:23:20 -0800
Message-ID: <F001.004205BF.20020306002320@fatcity.com>

Hi All

I have a 2 tables which related to each other Nemaster(primary key is Oid) and
Elements (Neid reference Oid)

Now I have to run following query

SELECT IPADDRESS FROM ELEMENTS WHERE NEID = (SELECT OID FROM NEMASTER WHERE EID = &ID);

I can run the above query as below

B) SELECT IPADDRESS FROM NEMASTER A, ELEMENTS B WHERE A.OID = B.NEID AND A.EID = @ID; If my Nemaster table is going to be bulkier and if I am using above queries in FUNCTIONS then how I should call the query. By method A or B.

Amol

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nandu Garg
INET: focussed_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 06 2002 - 02:23:20 CST