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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL function in a SELECT statement

Re: PL/SQL function in a SELECT statement

From: Bruno Pennec <Bruno.Pennec_at_der.edfgdf.fr>
Date: Thu, 24 Sep 1998 14:53:08 +0200
Message-ID: <360A40B4.24CBA588@der.edfgdf.fr>


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

Original text of this message

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