Re: Function that return recors

On Thu, 13 Dec 2001 13:34:22 +0100, "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> 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
>
>

You may want to read the "PL/SQL User's Guide and Reference". Specifically, Chapter 4, "Collections and Records".

Brian Received on Fri Dec 14 2001 - 08:48:34 CST