Attribution: This article is a complimentary excerpt from Oracle Advanced PL/SQL Developer Professional Guide Oracle initialization parameter PLSQL_OPTIMIZE_LEVEL The parameter was introduced in Oracle 10g to decide the level of optimization applicable for a program unit during compilation. The optimization during compilation means the removal of dead code, code movements to optimize iterative constructs, inline… Read More Enable code optimization technique using PLSQL_OPTIMIZE_LEVEL
Hi All, Oracle 11g saw through very significant PL/SQL feature i.e. Storage of external files/objects. These objects fall under unstructured data category and database recognises them as Large Objects. They are stored as LOB types in database. This normal storage was improved upon, after this philosophy slowly moved from ‘featured one’ to ‘overhead’ level in terms… Read More Oracle 11g SecureFiles
Hi guyzz, Check out my new online work at exforsys on Oracle 11g Read Only tables Read Only Tables Don’t forget to post your feedback. These days bit busy with Object model, I’ll be back soon with many more findings on Oracle stuffs. Bye for now-SBH Related articles Oracle Exadata Gains Certification for SAP Applications (pcworld.com)… Read More Read Only tables explained
Check Exception Handling in Oracle 11g http://www.exforsys.com/tutorials/oracle-11g/oracle-11g-exception-handling.html#.TfCvs_6fqIM;email — This message was sent by firstname.lastname@example.org via http://addthis.com. Please note that AddThis does not verify email addresses.
Check out my new publication at exforsys.com Oracle 11g Collections. Do post your feedbacks. Thanks – SBH
Check out my latest publication Oracle 11g Virtual Columns. Do post your feedbacks !!
Oracle Community The social network for Oracle people Saurabh Gupta Check out the blog post ‘Invisible indexes’Hi, View my latest publication.. http://www.exforsys.com/tutorials/oracle-11g/oracle-11g-invisible-index.html Do post your feedback !! Blog post link: Invisible indexes About Oracle Community For anyone interested in Oracle databases, applications and related technologies. 8655 members 486 photos 67 videos 948 discussions 212… Read More Check out “Invisible indexes” on Oracle Community