ORACLE PL/SQL and SQL
Bring me home...
PL/SQL FAQs
I have been meaning to put together a FAQ link for PL/SQL, but cann't seem to get around to it.
If you are a PL/SQL beginner, you might want to visit here.
That is where you can see all official ORACLE documentation for all things ORACLE, including PL/SQL.
Hierachical queries
Bulk Bind
Collections
Dynamic SQL
All kinds of argument
- Passing a ref cursor
- Passing a PL/SQL record?
- Passing an array?
Bind Variables
- Why bind variables?
- Bind variables and dynamic SQL
Analytic functions
Pipelined Table Functions(PTF)
Calling PL/SQL function from SQL
Outer Joins
Merge
Other interesting stuff...