Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function w/Record Param in SELECT?
Barry Johnson wrote:
> Is there a way to short-circuit this with something like?!?:
>
> SELECT Pkg.F( * ) FROM Tbl ;
>
You cannot do in this way according to the Oracle Manual. It says that stored procedure or function used in SQL statement cannot manipulate whole columns at the same time. It can only support row operations.
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Fri Dec 20 1996 - 00:00:00 CST