Re: dummy value?

From: Gunter Herrmann <notformail0106_at_earthlink.net>
Date: Wed, 21 Apr 2010 17:31:47 -0400
Message-ID: <4bcf6ec5$0$6765$9b4e6d93_at_newsspool3.arcor-online.net>



Hi!

joel garry wrote:

> One discussion: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425

This is 8i style.
As of 9i you don't need the cast any more in the select, just use

select * from table(myfunc(xyz))

If you want to return a lot of data use a pipelined table function to reduce memory consumption (also available as of 9i).

Best regards

Gunter, Orlando, Fl Received on Wed Apr 21 2010 - 16:31:47 CDT

Original text of this message