Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL question: function output appended to WHERE clause
Sybrand Bakker wrote:
> On 21 May 2004 11:37:00 -0700, sharkdba_at_yahoo.com (Sharkie) wrote:
>
<snip>
>
> You could try CASTing your output to the TABLE type.
> Also dbms_utility has a comma_to_table, and table_to_comma procedure.
>
> Usually using functions in selects, especially if the functions have
> their own selects is a safe recipe for performance problems, as the
> function's SELECT is considered recursive SQL and will *never* get
> merged in the main query
>
> And you don't need temp tables in Oracle.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
He could also try looking at Tom Kyte's site for "variable in list" or
variations thereof
Received on Fri May 21 2004 - 15:18:05 CDT
![]() |
![]() |