Function that returns a table and used in the from clause

[GeertVerhoeven]

Hi all,

For one of my project I needed a function that returns a table based on some parameters. In SQL Server this is pretty easy but in Oracle it took me quit some time.

Therefor I've posted a sample on how to do it on my blog.

http://geertverhoeven.blogspot.com/2007/07/create-function-that-returns-table.html

Any comments are welcome.

Greetz,

Geert

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog