Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL function in a SELECT statement
I would like but i can't because "my_function" contains
big requests and calculations and it will very inefficient
to test all values.
have you got a other solution ?
thanks,
bruno
> I think you'd better write something like:
>
> SELECT column1 FROM table1 WHERE my_function(column2) = 1
>
> >
> > I need to do a SELECT statement like :
> >
> > SELECT column1 FROM table1 WHERE column2 in my_function;
> >
> > ( where my_function is a PL/SQL function. )
> >
> > My_function must return a list of items.
> > What type must i use for the result of "my_function" ?
> > (for example : column2 is a varchar2)
> >
Received on Thu Sep 24 1998 - 07:53:08 CDT