Dynamic SQL

Get Columns from Ref Cursor

You've got some dynamic application where you want to access some meta data from a ref cursor? Two examples are right here!

Display Oracle Session ID (SID)

When you work with views like v$session you'll often want to know the current session ID. Here's how you can get it.

Deterministic Functions to improve Performance

Make functions in queries faster by declaring them as deterministic