Oracle Pipelined Table Functions

Basically, when you would like a PLSQL (or java or c) routine to be the «source» of data — instead of a table — you would use a pipelined function. PIPELINED functions will operate like a table.

Read More - Register for Free Membership