• Brief introduction into Materialized Views
  The Oracle Instructor Tune Materialized views
  with 11g introduction materialized oracle teaching tuning views
• Conditions Based On Inequalities Can't Use Indexes
  How To Resolve? - ORACLE IN ACTION
  with conditions indexes inequalities
• LISTAGG and PIVOT functions in Oracle 11g R2
  Abstract Confusions
  with 11g 11gr2 listagg oracle pivot
• Oracle Hints SQL PL/SQL
  Decent overview of hints you can use in either PL/SQL or SQL routines. Especially helpful for me was CACHE hint that I used in Subquery factoring (WITH clause).
  with 11g cache hint hints oracle plsql sql
• PL/SQL Ref cursors dynamic SQL
  Understanding Ref Cursors | Oracle Forums
  with cursors example forums function oracle plsql ref simple
• Ask Tom "How can I do a variable "in list""
  SQL, PL/SQL, table functions, bind variables, variable content
  with bind content functions plsql sql table variable variables
• Pivot, unpivot from Arup Nanda Oracle 11g
  Pivot, unpivot from Arup Nanda Oracle Database 11g: The Top Features for DBAs and Developers by Arup Nanda Oracle ACE Director Pivot and Unpivot
  with 11g arup dba developers features for nanda oracle pivot top unpivot
• PL/SQL Practices
  First Things First -- mentions new Oracle 11g PL/SQL capabilities. Suggests some good practices development and ways of testing, profiling code
  with dbms_hprof dbms_profiler plscope
• PLSQL 101
  FORALL bulk collect examples in PL/SQL
  with bulk exceptions forall indices of
• Oracle Ref Cursors
  with cursors oracle ref
• Programs
  Oracle Practicals...
  with dbms_scheduler
• View Book
  with book view
  Note: PL/SQL XML

Bookmarks 1 - 12