Netvouz / MondoTofu / folder / PL/SQL 11g http://netvouz.com/MondoTofu/folder/5811424199073218275/Oracle+PL+SQL+11g?feed=rss MondoTofu's bookmarks in folder PL/SQL 11g on Netvouz Brief introduction into Materialized Views http://uhesse.com/2009/07/08/brief-introduction-into-materialized-views/ The Oracle Instructor Tune Materialized views Oracle > PL/SQL 11g MondoTofu Tue, 20 Aug 2013 00:25:12 GMT Conditions Based On Inequalities Can't Use Indexes http://oracleinaction.com/conditions-based-inequalities-cant-use-indexes-toresolve/ How To Resolve? - ORACLE IN ACTION Oracle > PL/SQL 11g MondoTofu Fri, 04 May 2018 13:40:12 GMT LISTAGG and PIVOT functions in Oracle 11g R2 http://guruparan18.wordpress.com/2009/12/02/listagg-and-pivot-functions-in-oracle-11g-r2/ Abstract Confusions Oracle > PL/SQL 11g MondoTofu Thu, 14 Nov 2013 19:19:32 GMT Oracle Hints SQL PL/SQL http://psoug.org/reference/hints.html 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). Oracle > PL/SQL 11g MondoTofu Fri, 12 Jul 2013 18:13:52 GMT PL/SQL Ref cursors dynamic SQL https://forums.oracle.com/thread/888365?start=0&tstart=0 Understanding Ref Cursors | Oracle Forums Oracle > PL/SQL 11g MondoTofu Fri, 04 Oct 2013 17:44:47 GMT Ask Tom "How can I do a variable "in list"" http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425 SQL, PL/SQL, table functions, bind variables, variable content Oracle > PL/SQL 11g MondoTofu Wed, 19 Dec 2012 16:48:35 GMT Pivot, unpivot from Arup Nanda Oracle 11g http://www.oracle.com/technetwork/articles/sql/11g-pivot-097235.html Pivot, unpivot from Arup Nanda Oracle Database 11g: The Top Features for DBAs and Developers by Arup Nanda Oracle ACE Director Pivot and Unpivot Oracle > PL/SQL 11g MondoTofu Fri, 24 Jan 2014 21:29:02 GMT PL/SQL Practices http://www.oracle.com/technology/oramag/oracle/09-jul/o49plsql.html First Things First -- mentions new Oracle 11g PL/SQL capabilities. Suggests some good practices development and ways of testing, profiling code Oracle > PL/SQL 11g MondoTofu Wed, 18 Nov 2009 02:17:56 GMT PLSQL 101 http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52plsql-1709862.html FORALL bulk collect examples in PL/SQL Oracle > PL/SQL 11g MondoTofu Wed, 02 Jan 2013 19:38:48 GMT Oracle Ref Cursors http://psoug.org/reference/ref_cursors.html Oracle > PL/SQL 11g MondoTofu Wed, 17 Nov 2010 18:27:46 GMT