Re: DBA requires basic SQL assistance please (LONG POST)

Originally posted by Norman Dunbar
> Afternon all,
>
> =====================
> Oracle 8174 EE 64 bit.
> HPUX 11.00 64 bit.
> =====================
>
> I'm certain I've done this before, but try as I might, I cannot
> seems to
> make it work now ! What I think I've done before is this :
>
> select * from table where something in (some_function());
>
> but, the bit in parenthesis is generated as output from a function
> either via an OUT parameter or by a direct function result. So the
> function returns and the in clause 'just worked'. Or at
> least, that's what I think happened.
>
> <snip>
>

This link should help you
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:21- 0612357425

rajXesh

--
All you need in this life is ignorance and confidence, and then success is sure. -- Mark Twain (1835 - 1910)


Posted via http://dbforums.com