MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Pipelined Functions & PL/SQL Tables

without comments

Pipelined functions let you retrieve record structures from PL/SQL Tables as rows in SQL statements. PL/SQL tables are also known as associative arrays from 10g forward. While pipelined functions are slower than other approaches, they are easy to implement. The alternative uses a complex query. The query is complex because it typically uses selective aggregation and nested CASE logic.

Read more …

Written by maclochlainn

May 11th, 2008 at 8:25 pm