Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Function that return recors
becouse this_function(...) must returns elements from table that have about
300 000 rows. Timing of it is about 1 second.
Then if I select from table my_table than have abot 10 000 rows it shuld
work 10 000 seconds (1 second * 10 000), I suppose.
That's why I'm looking for somethink else. Or am I wrong?
Slawek Marcinkowski
Uzytkownik "Glebsky" <glebsky_at_gmx.net> napisal w wiadomosci
news:3C19DEE8.ECFA7222_at_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 - 06:30:52 CST