Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table function with unknown column list
On Feb 22, 10:57 am, dev..._at_gmail.com wrote:
> Hello all,
>
> I'm trying to solve a problem and I have to do this query:
>
> select a.* from tab1 a join view1 b on a.id = b.id;
>
> The problem is that view1 is a very large/complex object and when I
> have to filter rows this way:
>
> select a.* from tab1 a join view1 b on a.id = b.id where a.id = 5;
>
> I obtain execution times absolutely out of range....noway.
>
> I would like to create a pipelined function that filter results BEFORE
> doing join operations, so I will obtain this:
>
> select a.* from tab1 a join (select * from table(select * from
> tbfunct('5'))) tbfunc1 b on a.id = b.id;
>
> I tried to do this with a view that has "where id = 5" in its code and
> it works well, so I started to write code but I can't declare a record
> type that has unknown column list...because I don't want to add or
> remove columns in function table whenever a modification in underlined
> table occurs.
>
> I hope I explained the situation well...:)
>
> Any help appreciated.
>
> Regards.
Have you tried to declare the record as: <table_name>%ROWTYPE? Received on Thu Feb 22 2007 - 10:45:25 CST