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

Home -> Community -> Usenet -> c.d.o.server -> Re: Function that return recors

Re: Function that return recors

From: Glebsky <glebsky_at_gmx.net>
Date: Fri, 14 Dec 2001 17:13:44 +0600
Message-ID: <3C19DEE8.ECFA7222@gmx.net>


Why dont you use the design like this:

SELECT my_column FROM my_table
  WHERE this_function(other_colulmn, param1, param2);

Regards

"Sławomir Marcinkowski" wrote:

> Can somebody show me function that returns many record?
>
> I need to write this, becouse I need somethink like this:
>
> SELECT
> my_column
> FROM
> my_table
> WHERE
> other_colulmn in (
> SELECT this_function(param1,param2) FROM dual
> );
>
> Slawek Marcinkowski
Received on Fri Dec 14 2001 - 05:13:44 CST

Original text of this message

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