Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

December 28, 2006

Expanded Supplied Packages with 10g – Part I

Filed under: Oracle 10g New Features — H.Tonguç Yılmaz @ 1:33 pm

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 »

  1. […] Expanded Supplied Packages with 10g – Part 2 Filed under: Oracle 10g New Feature — H.Tonguç Yılmaz @ 12:58 pm In Part 1 I mentioned how pl/sql is empowered by new supplied packages and the importance of using them. […]

    Pingback by Expanded Supplied Packages with 10g - Part 2 « H.Tonguç YILMAZ Oracle Blog — December 29, 2006 @ 1:03 pm | Reply

  2. […] – Oracle Expanded Supplied Packages with 10g Series Like DBMS_APPLICATION_INFO, UTL_COMPRESS, DBMS_DB_VERSION etc. […]

    Pingback by H.Tonguç YILMAZ Blog » Last warning, I moved my blog - Son uyarı, taşındım — December 30, 2006 @ 6:35 am | Reply

  3. […] with 10g – Part 3 Filed under: Oracle 10g New Feature — H.Tonguç Yılmaz @ 1:01 pm In Part 1 I mentioned how pl/sql is empowered by new supplied packages and the importance of using […]

    Pingback by Expanded Supplied Packages with 10g - Part 3 « H.Tonguç YILMAZ Oracle Blog — January 5, 2007 @ 2:10 pm | Reply

  4. […] Oracle Expanded Supplied Packages with 10g Series Like DBMS_APPLICATION_INFO, UTL_COMPRESS, DBMS_DB_VERSION […]

    Pingback by H.Tonguç YILMAZ Blog » One more warning, I moved my blog - Bir uyarı daha, taşındım — April 26, 2007 @ 7:59 pm | Reply

  5. […] 10g I tried to blog my experiences on new and updated pl/sql packages and with a series called Expanded Supplied Packages with 10g. If you do not want to waste your time and money on developing some features which are already […]

    Pingback by Oracle provides SQL and PL/SQL features so that we can do a lot more with fewer lines of code « H.Tonguç YILMAZ Oracle Blog — February 8, 2008 @ 7:47 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: