As with Friday's post , pipelined functions are something I use rarely, thus end up looking up how to do it. So with a little help fro...

One concept of Oracle that I've always been intrigued by is Nested Tables. Nested tables are, basically, a table (dataset) stored in a ...

So I was writing a small procedure to loop through a procedure's arguments (all_arguments). After getting it working, I then began to po...