Beside New Dictionary Enhancements with 10g Series I will start to write on Expanded Supplied Packages with 10g. With 10g several packages upgraded and enhanced, also documentation is upgraded. “catproc.sql” can be used to identify these packages installed by default.
– Oracle 9iR2 Supplied PL/SQL Packages & Types Reference Covers 101 Packages
– Oracle 10gR1 PL/SQL Packages & Types Reference Covers 166 Packages
– Oracle 10gR2 PL/SQL Packages & Types Reference Covers 180 Packages
– New Oracle9i Oracle Supplied Packages (19)
| DBMS_APPLY_ADM | DBMS_CAPTURE_ADM |
| DBMS_FGA | DBMS_FLASHBACK |
| DBMS_LDAP | DBMS_LIBCACHE |
| DBMS_LOGMNR_CDC_PUBLISH | DBMS_LOGMNR_CDC_SUBSCRIBE |
| DBMS_METADATA | DBMS_ODCI |
| DBMS_OUTLN_EDIT | DBMS_REDEFINITION |
| DBMS_TRANSFORM | DBMS_WM |
| DBMS_XMLGEN | DBMS_XMLQUERY |
| DMBS_XMLSAVE | UTL_ENCODE |
| UTL_URL |
– New Oracle9i R2 Oracle Supplied Packages (18)
| DBMS_APPLY_ADM | DBMS_CAPTURE_ADM |
| DBMS_LOGSTDBY | DBMS_MGWADM |
| DBMS_MGWMSG | DBMS_PROPAGATION_ADM |
| DBMS_RULE | DBMS_RULE_ADM |
| DBMS_STORAGE_MAP | DBMS_STREAMS |
| DBMS_STREAMS_ADM | DBMS_XDB |
| DBMS_XDBT | DBMS_XDB_VERSION |
| DBMS_XMLDOM | DBMS_XMLPARSER |
| DBMS_XPLAN | DBMS_XSLPROCESSOR |
– New Oracle10g R1 Oracle Supplied Packages (51) and 60 Packages Updates in Oracle10gR1
| DBMS_ADVANCED_REWRITE | DBMS_SERVICE |
| DBMS_ADVISOR | DBMS_SQLTUNE |
| DBMS_CRYPTO | DBMS_STAT_FUNCS |
| DBMS_DATAPUMP | DBMS_STREAMS_AUTH |
| DBMS_DATA_MINING | DBMS_STREAMS_MESSAGING |
| DBMS_DATA_MINING_TRANSFORM | DBMS_STREAMS_TABLESPACE_ADM |
| DBMS_DIMENSION | DBMS_WARNING |
| DBMS_FILE_TRANSFER | DBMS_WORKLOAD_REPOSITORY |
| DBMS_FREQUENT_ITEMSET | DBMS_XDBZ |
| DBMS_JAVA | DBMS_XMLSTORE |
| DBMS_MONITOR | HTF |
| DBMS_SCHEDULER | HTMLDB_APPLICATION |
| DBMS_SERVER_ALERT | HTMLDB_CUSTOM_AUTH |
| HTMLDB_ITEM | SDO_GEOR |
| HTMLDB_UTIL | SDO_GEOR_UTL |
| HTP | SDO_NET |
| OWA_CACHE | SDO_SAM |
| OWA_COOKIE | SDO_TOPO |
| OWA_CUSTOM | SDO_TOPO_MAP |
| OWA_IMAGE | UTL_COMPRESS |
| OWA_OPT_LOCK | UTL_DBWS |
| OWA_PATTERN | UTL_I18N |
| OWA_SEC | UTL_LMS |
| OWA_TEXT | UTL_MAIL |
| OWA_UTIL | WPG_DOCLOAD |
| SDO_GCDR |
– New Oracle10g R2 Oracle Supplied Packages (14) and 53 Packages Updates in Oracle10gR2
| DBMS_AQELM | DBMS_FILE_GROUP |
| DBMS_AQIN | DBMS_PREDICTIVE_ANALYTICS |
| DBMS_CHANGE_NOTIFICATION | DBMS_PREPROCESSOR |
| DBMS_DB_VERSION | DBMS_RLMGR |
| DBMS_EPG | DBMS_TDB |
| DBMS_ERRLOG | SDO_NET_MEM |
| DBMS_EXPFIL | UTL_NLA |
PL/SQL has grown tremendously with Oracle 10g R1 and R2. This growth includes a wide range of both DBA and Developer enhancements. We need to learn these features and make sure thoroughly understand these prior to start using. Knowing what Oracle has provided will expand your arsenal, utilize your cost and get you a competitive advantage especially in terms of being time-to-market. These packages are all supported by Oracle and tested over and over again, so dont reinvent the wheel and get rid of the maintenance costs of a newly developed applications ;)
Continue reading with Part 2
References used :
“The PL/SQL Grid: Time to Expand to 10g R1 & 10g R2¨ presentation by Joe Trezzo
What’s New in PL/SQL in Oracle Database 10g? Oracle Technology Network(OTN) Paper
5 Comments