Re: joining streamed pipelined function results with "real" tables

From: Gunter Herrmann <notformail0106_at_earthlink.net>
Date: Fri, 03 Sep 2010 14:13:46 -0400
Message-ID: <4c813adc$0$6882$9b4e6d93_at_newsspool2.arcor-online.net>



Hi!

Frank Bergemann wrote:

> select something(rec.x, rec.y, rec.z) bulk collect into data
> from table(cast (dynData(cur) as table_of_something)) rec,
> account acct
> where acct.acct_id = rec.x;

As of 9i you do not need the CAST ... AS any more. Select something from TABLE(my_table_function(arg1,arg2)) will be fine.

Regards

Gunter in Orlando, Fla Received on Fri Sep 03 2010 - 13:13:46 CDT

Original text of this message