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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: is it possible to use a function to

RE: is it possible to use a function to

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 24 Feb 2005 15:43:46 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C86@irvmbxw02>


Ask Tom Kyte:
varying elements in IN list
http://asktom.oracle.com/pls/ask/f?p=4950:8:8321215185943122431::NO::F49 50_P8_DISPLAYID,F4950_P8_CRITERIA:110612348061 or
http://tinyurl.com/4u6fc
-----Original Message-----

Duret, Kathy

8.1.7.4 Solaris 9
What I want to do is build a In list and feed it to a query:

select * from test2 where
symbol in ( select test_function('IBM') symbol from dual);

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 24 2005 - 18:46:55 CST

Original text of this message

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