Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Function that return recors
Privet, Slawomir
You are right, my offer was based on my wrong assumption that "this_function"
is tiny and fast .
In your case it could be better to make function to build some "dictionary
table"
like they do it in data warehousing.
Regards
Slawomir Marcinkowski wrote:
> 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 Mon Dec 17 2001 - 03:00:08 CST