Programming/
 Tools

      Oracle
      JavaScript
      C#

 Fun Stuff
      Music
      Martial Arts
      Robotech

 Other
      Main


DISCLAIMER
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.

Alphabet Table SQL Script
The function should return the following data...
UPPER_CHARACTERLOWER_CHARACTERSORT_ORDERUPPER_ASCII_CODELOWER_ASCII_CODE
Aa16597
Bb26698
Cc36799
Dd468100
Ee569101
Ff670102
Gg771103
Hh872104
Ii973105
Jj1074106
Kk1175107
Ll1276108
Mm1377109
Nn1478110
Oo1579111
Pp1680112
Qq1781113
Rr1882114
Ss1983115
Tt2084116
Uu2185117
Vv2286118
Ww2387119
Xx2488120
Yy2589121
Zz2690122

ASCII Character Table SQL Script


If you find any bugs or want to contact me I can be reached @ doughjoe77@hotmail.com.