This disclaimer is intended to cover all software/freeware, and other various files which are downloadable through or from this site. |
Joe Garrepy, isp, and web host can not be held responsible for any software downloaded from this site. All freeware is downloaded at your own risk. Software which is listed on this site is assumed to work properly, but may or may not have different effects on different computer systems. The same rules apply to these programs.
Joe Garrepy assumes no responsibility for those unusual occurrences where software has adverse effects on users computer. Joe Garrepy does not warrant these programs/files, and as such, can offer no guidelines in which to use them.
All freeware/software/files, trademarks, service marks, and copyrights are acknowledged as belonging to their owners. Any of these which the owner wishes to be removed will be done so immediately.
By downloading any software or viewing pages in which software can be downloaded, you agree to be bound to this agreement.
JoeGarrepy.com Oracle Pipelined Function Example
A powerful new feature in Oracle 9i is the Pipelined Function or the Parameterized View. You can now create functions that return rows like selecting from a table or view. I can see about a million things you could do with this including optimizing really bizarre queries and using it to truly control what Oracle Reports does. I've always had a problem with how Oracle Reports returns data from the Oracle Reports Datamodel. With a Pipelined function though, you can control right in PL what is returned. I've been testing this in Oracle Reports 6.0 and it works great!
There are two examples of a piplined function on this page. The first returns a table of the Alphabet while the second returns an ASCII Character Codes chart.
The function should return the following data...
Alphabet Table SQL Script
ASCII Character Table SQL Script