Netvouz / MondoTofu / tag / plsql http://netvouz.com/MondoTofu/tag/plsql?feed=rss MondoTofu's bookmarks tagged "plsql" on Netvouz How to select statements from AWR? (Upgrade your Database - NOW!) https://blogs.oracle.com/UPGRADE/entry/how_to_select_statements_from How to pick SQL statements out of AWR to create a workload for DBMS_Advisor runs Oracle > Optimization MondoTofu Thu, 09 Apr 2015 20:19:53 GMT Howto Create Resource Access Descriptors For Oracle9i Forms Single Sign-On With Plsql http://www.oracle.com/technetwork/developer-tools/forms/howtoplsqlrad-101335.html FORMS_RAD code PL/SQL Oracle > Forms Reports 11gR2 MondoTofu Thu, 01 Mar 2012 14:46:01 GMT improving performance with pipelined table functions http://www.oracle-developer.net/display.php?id=429 Excerpt on pipelined table functions from Feuerstein book on PL/SQL Oracle > DB 11g MondoTofu Fri, 28 Dec 2012 20:10:09 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 ORACLE-BASE http://www.oracle-base.com/articles/misc/xml-over-http.php XML-Over-HTTP (REST Web Services) From PL/SQL Oracle > WebServices 11g MondoTofu Fri, 11 May 2012 15:29:18 GMT OTN Discussion Forums https://forums.oracle.com/forums/thread.jspa?threadID=2174552 SQL and PL/SQL FAQ ... Oracle > PL/SQL MondoTofu Thu, 21 Mar 2013 14:28:21 GMT pivot and unpivot queries in 11g http://www.oracle-developer.net/display.php?id=506 pivot, unpivot from Adrian Billington Oracle > DB 11g MondoTofu Fri, 24 Jan 2014 21:33:29 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 The Oracle PL/SQL WITH Clause http://psoug.org/definition/WITH.htm Oracle > DB 11g MondoTofu Tue, 23 Apr 2013 18:06:53 GMT Using Python With Oracle Database 11g http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/OOW11/python_db/python_db.htm elementary work with arrays cx_Oracle pl/sql and Python2.6 python MondoTofu Fri, 26 Aug 2016 13:09:21 GMT