What's New in PL/SQL Packages and Types Reference?

The following sections describe the new features in Oracle PL/SQL Packages and Types Reference:

• Oracle Database 10g Release 1 (10.1) New Features
  • New Packages
  • New Types
  • Updated Packages
  • Updated Types
• Oracle9i Release 2 (9.2) New Features
• Oracle9i Release 1 (9.0.1) New Features
• Oracle8i Release 2 (8.1.6) New Features
• Oracle8i Release 1 (8.1.5) New Features

Oracle Database 10g Release 1 (10.1) New Features

New Packages

• DBMS_ADVANCED_REWRITE
• DBMS_ADVISOR
• DBMS_CRYPTO
• DBMS_DATAPUMP
• DBMS_DATA_MINING
• DBMS_DATA_MINING_TRANSFORM
• DBMS_DIMENSION
• DBMS_FILE_TRANSFER
• DBMS_FREQUENT_ITEMSET
• DBMS_JAVA
• DBMS_MONITOR
• DBMS_SCHEDULER
• DBMS_SERVER_ALERT
• DBMS_SERVICE
• DBMS_SQLTUNE
• DBMS_STAT_FUNCS
• DBMS_STREAMS_AUTH
• DBMS_STREAMS_MESSAGING
• DBMS_STREAMS_TABLESPACE_ADM
• DBMS_WARNING
• DBMS_WORKLOAD_REPOSITORY
• DBMS_XDBZ
• DBMS_XMLSTORE
• HTF
• HTMLDB_CUSTOM_AUTH
• HTMLDB_APPLICATION
• HTMLDB_ITEM
• HTMLDB_UTIL
• HTP
• OWA_CACHE
• OWA_COOKIE
• OWA_CUSTOM
• OWA_IMAGE
• OWA_OPT_LOCK
• OWA_PATTERN
• OWA_SEC
• OWA_TEXT
• OWA_UTIL
• SDO_GCDR
• SDO_GEOR
• SDO_GEOR_UTL
• SDO_NET
• SDO_SAM
• SDO_TOPO
• SDO_TOPO_MAP
• UTL_COMPRESS
• UTL_DBWS
• UTL_I18N
• UTL_LMS
• UTL_MAIL
• UTL_RECOMP
• WPG_DOCLOAD

New Types

• Database URI TYPEs
• XMLTYPE

Updated Packages

• DBMS_APPLICATION_INFO
• DBMS_APPLY_ADM
• DBMS_AQ
• DBMS_AQADM
• DBMS_AQELM
• DBMS_CAPTURE_ADM
• DBMS_CDC_PUBLISH
• DBMS_CDC_SUBSCRIBE
• DBMS_DDL
• DBMS_DESCRIBE
• DBMS_DISTRIBUTED_TRUST_ADMIN
• DBMS_FGA
• DBMS_JOB
• DBMS_LIBCACHE
• DBMS_LOB
• DBMS_LOGMNR
• DBMS_LOGMNR_D
• DBMS_METADATA
• DBMS_MGWADM
• DBMS_MGWMSG
• DBMS_MVIEW
• DBMS_OBFUSCATION_TOOLKIT
• DBMS_OLAP
• DBMS_OUTLN
• DBMS_OUTLN_EDIT
• DBMS_OUTPUT
• DBMS_PROPAGATION_ADM
• DBMS_REDEFINITION
• DBMS_REDEFINITION
• DBMS_RESOURCE_MANAGER
• DBMS_RLS
• DBMS_ROWID
• DBMS_RULE
• DBMS_RULE_ADM
• DBMS_SESSION
• DBMS_SPACE
• DBMS_SQL
• DBMS_STATS
• DBMS_STREAMS
• DBMS_STREAMS_ADM
• DBMS_TTS
• DBMS_TYPES
• DBMS_UTILITY
• DBMS_WM
• DBMS_XDB
• DBMS_XDB_VERSION
• DBMS_XMLGEN
• DBMS_XMLSCHEMA
• DBMS_XPLAN
• DBMS_XSLPROCESSOR
• DBMS_WM
• SDO_CS
• SDO_GEOM
• SDO_LRS
• SDO_MIGRATE
• SDO_TUNE
• SDO_UTIL
• UTL_ENCODE
• UTL_FILE
• UTL_RAW
• UTL_URL

Updated Types

• ANYDATA TYPE
• ANYDATASET TYPE
• Oracle Streams AQ TYPEs
• Logical Change Record TYPEs
• Rule TYPEs

Oracle9i Release 2 (9.2) New Features

This release includes the following new chapters:

• Advanced Queuing Types
• 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
• JMS Types
• Logical Change Record Types
• Rule Types

This release includes changes to the following chapters:

• DBMS_DDL
• DBMS_FLASHBACK
• DBMS_LOB
• DBMS_LOGMNR
• DBMS_LOGMNR_CDC_PUBLISH
• DBMS_LOGMNR_CDC_SUBSCRIBE
• DBMS_LOGMNR_D
• DBMS_METADATA
• DBMS_REDEFINITION
• DBMS_RLS
• DBMS_SPACE_ADMIN
• DBMS_STATS
• DBMS_TRANSFORM
• DBMS_WM
• DBMS_XMLGEN
• DBMS_XMLQUERY
• DBMS_XMLSAVE
• DBMS_XMLSchema
• UTL_FILE
• UTL_HTTP

Oracle9i Release 1 (9.0.1) New Features

This release includes the following new packages:

• DBMS_AQELM
• DBMS_ENCODE
• 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_URL
• DBMS_WM
• DBMS_XMLGEN
• DBMS_XMLQuery
• DMBS_XMLSave
• UTL_ENCODE

This release includes new information about types:

• DBMS_TYPES
• ANYDATA_TYPE
• ANYDATASET_TYPE
• ANYTYPE_TYPE

This release includes enhancements to the following packages:

• UTL_FILE
• UTL_HTTP
• UTL_RAW

Oracle8i Release 2 (8.1.6) New Features

This release included the following new packages

• DBMS_BACKUP_RESTORE
• DBMS_OBFUSCATION_TOOLKIT
• UTL_INADDR
• UTL_SMTP
• UTL_TCP

This release included enhancements to the following packages:

• DBMS_DEBUG
• DBMS_DISTRIBUTED_TRUST_ADMIN
• DBMS_LOGMINER
• DBMS_LOGMINER_D
• DBMS_PCLXUTIL
• DMBS_PROFILER
• DBMS_REPAIR
• DBMS_RESOURCE_MANAGER
• DBMS_ROWID
• DBMS_SQL
• DBMS_UTILITY
• UTL_HTTP

Oracle8i Release 1 (8.1.5) New Features

This book was new for release 8.1.5.