Re: SQL question: function output appended to WHERE clause

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 21 May 2004 20:21:01 GMT
Message-ID: <Nwtrc.1808$ZQ.229@nwrddc03.gnilink.net>

"Sharkie" <sharkdba_at_yahoo.com> wrote in message news:423b5ab1.0405211037.41048b2e_at_posting.google.com...
> Hello,
>
> I'm using Oracle 8.1.7 on a Solaris box.
> This might be a simple problem, not sure, but I really need this to work.
--snip--
> I can easily select the rows I need manually through:
> select * from temp where id in (1,2,5);
>
> Now, let's say I have a function which returns '1,2,5'.
>
> SQL> select f_temp from dual;
> 1,2,5
>
> Can I use this function to get the same results?
--snip--

How to do this changes between 8i and 9i:

Look at the following link (might wrap): http://asktom.oracle.com/pls/ask/f?p=4950:8:5090242793999609968::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:110612348061,

Not sure if Tom had the 9i example in this .. You can search for "pipelined" for 9i examples

Anurag Received on Fri May 21 2004 - 15:21:01 CDT