oracle提供PL/SQL包

转自http://blog.sina.com.cn/s/blog_6d6e54f70100zh7j.html

Package Name	Description
CTX_ADM	Lets you administer servers and the data dictionary.
CTX_CLS	Lets you generate CTXRULE rules for a set of documents.
CTX_DDL	Lets you create and manage the preferences, section lists andstopgroups required for Text indexes.
CTX_DOC	Lets you request document services.
CTX_OUTPUT	Lets you manage the index log.
CTX_QUERY	Lets you generate query feedback, count hits, and create storedquery expressions.
CTX_REPORT	Lets you create various index reports.
CTX_THES	Lets you to manage and browse thesauri.
CTX_ULEXER	For use with the user-lexer.
DBMS_ADVANCED_REWRITE	Contains interfaces for advanced query rewrite users to create,drop, and maintain functional equivalence declarations for queryrewrite.
DBMS_ADVISOR	Part of the SQLAccess Advisor, an expert system that identifiesand helps resolve performance problems relating to the execution ofSQL statements.
DBMS_ALERT	Provides support for the asynchronous notification of databaseevents.
DBMS_APPLICATION_INFO	Lets you register an application name with the database forauditing or performance tracking purposes.
DBMS_APPLY_ADM	Provides administrative procedures to start, stop, and configurean apply process.
DBMS_AQ	Lets you add a message (of a predefined object type) onto aqueue or to dequeue a message.
DBMS_AQADM	Lets you perform administrative functions on a queue or queuetable for messages of a predefined object type.
DBMS_AQELM	Provides procedures to manage the configuration of AdvancedQueuing asynchronous notification by e-mail and HTTP.
DBMS_AQIN	Plays a part in providing secure access to the Oracle JMSinterfaces.
DBMS_CAPTURE_ADM	Describes administrative procedures to start, stop, andconfigure a capture process; used in Streams.
DBMS_CDC_PUBLISH	Identifies new data that has been added to, modified, or removedfrom, relational tables and publishes the changed data in a formthat is usable by an application.
DBMS_CDC_SUBSCRIBE	Lets you view and query the change data that was captured andpublished with the DBMS_LOGMNR_CDC_PUBLISH package.
DBMS_CHANGE_NOTIFICATION	Is part of a set of features that clients use to receivenotifications when result sets of a query have changed. The packagecontains interfaces that can be used by mid-tier clients toregister objects and specify delivery mechanisms.
DBMS_CRYPTO	Lets you encrypt and decrypt stored data, can be used inconjunction with PL/SQL programs running network communications,and supports encryption and hashing algorithms.
DBMS_DATA_MINING	Lets you use data mining to discover hidden patterns and usethat knowledge to make predictions.
DBMS_DATA_MINING_TRANSFORM	Provides set of data transformation utilities available for usewith the DBMS_DATA_MINING package for preparing mining data.
DBMS_DATAPUMP	Lets you move all, or part of, a database between databases,including both data and metadata.
DBMS_DB_VERSION	Specifies the Oracle version numbers and other informationuseful for simple conditional compilation selections based onOracle versions.
DBMS_DDL	Provides access to some SQL DDL statements from storedprocedures, and provides special administration operations notavailable as DDLs.
DBMS_DEBUG	Implements server-side debuggers and provides a way to debugserver-side PL/SQL program units.
DBMS_DEFER	Provides the user interface to a replicated transactionaldeferred remote procedure call facility. Requires the DistributedOption.
DBMS_DEFER_QUERY	Permits querying the deferred remote procedure calls (RPC) queuedata that is not exposed through views. Requires the DistributedOption.
DMBS_DEFER_SYS	Provides the system administrator interface to a replicatedtransactional deferred remote procedure call facility. Requires theDistributed Option.
DBMS_DESCRIBE	Describes the arguments of a stored procedure with full nametranslation and security checking.
DBMS_DIMENSION	Enables you to verify dimension relationships and provides analternative to the Enterprise Manager Dimension Wizard fordisplaying a dimension definition
DBMS_DISTRIBUTED_TRUST_ADMIN	Maintains the Trusted Database List, which is used to determineif a privileged database link from a particular server can beaccepted.
DBMS_EPG	Implements the embedded PL/SQL gateway that enables a webbrowser to invoke a PL/SQL stored procedure through an HTTPlistener.
DBMS_ERRLOG	Provides a procedure that enables you to create an error loggingtable so that DML operations can continue after encountering errorsrather than abort and roll back.
DBMS_EXPFIL	Contains all the procedures used to manage attribute sets,expression sets, expression indexes, optimizer statistics, andprivileges by Expression Filter.
DBMS_FGA	Provides fine-grained security functions.
DBMS_FILE_GROUP	One of a set of Streams packages, provides administrativeinterfaces for managing file groups, file group versions, files andfile group repositories.
DMBS_FILE_TRANSFER	Lets you copy a binary file within a database or to transfer abinary file between databases.
DMBS_FLASHBACK	Lets you flash back to a version of the database at a specifiedwall-clock time or a specified system change number (SCN).
DBMS_FREQUENT_ITEMSET	Enables frequent itemset counting.
DBMS_HS_PASSTHROUGH	Lets you use Heterogeneous Services to send pass-through SQLstatements to non-Oracle systems.
DBMS_IOT	Creates a table into which references to the chained rows for anIndex Organized Table can be placed using the ANALYZEcommand.
DBMS_JAVA	Provides a PL/SQL interface for accessing database functionalityfrom Java
DBMS_JOB	Lets you schedule administrative procedures that you wantperformed at periodic intervals; it is also the interface for thejob queue.
DBMS_LDAP	Provides functions and procedures to access data from LDAPservers.
DBMS_LDAP_UTL	Provides the Oracle Extension utility functions for LDAP.
DBMS_LIBCACHE	Prepares the library cache on an Oracle instance by extractingSQL and PL/SQL from a remote instance and compiling this SQLlocally without execution.
DBMS_LOB	Provides general purpose routines for operations on Oracle LargeObject (LOBs) datatypes - BLOB,CLOB (read/write), and BFILEs(read-only).
DBMS_LOCK	Lets you request, convert and release locks through Oracle LockManagement services.
DBMS_LOGMNR	Provides functions to initialize and run the log reader.
DBMS_LOGMNR_D	Queries the dictionary tables of the current database, andcreates a text based file containing their contents.
DBMS_LOGSTDBY	Describes procedures for configuring and managing the logicalstandby database environment.
DBMS_METADATA	Lets callers easily retrieve complete database objectdefinitions (metadata) from the dictionary.
DBMS_MGWADM	Describes the Messaging Gateway administrative interface; usedin Advanced Queuing.
DBMS_MGWMSG	Describes object types—used by the canonical message types toconvert message bodies—and helper methods, constants, andsubprograms for working with the Messaging Gateway message types;used in Advanced Queuing.
DBMS_MONITOR	Let you use PL/SQL for controlling additional tracing andstatistics gathering.
DBMS_MVIEW	Lets you refresh snapshots that are not part of the same refreshgroup and purge logs. DBMS_SNAPSHOT is a synonym.
DBMS_OBFUSCATION_TOOLKIT	Provides procedures for Data Encryption Standards.
DBMS_ODCI	Returns the CPU cost of a user function based on the elapsedtime of the function.
DBMS_OFFLINE_OG	Provides public APIs for offline instantiation of mastergroups.
DBMS_OLAP	Provides procedures for summaries, dimensions, and queryrewrites.
DBMS_OUTLN	Provides the interface for procedures and functions associatedwith management of stored outlines. Synonymous withOUTLN_PKG
DBMS_OUTLN_EDIT	Lets you edit an invoker's rights package.
DBMS_OUTPUT	Accumulates information in a buffer so that it can be retrievedlater.
DBMS_PCLXUTIL	Provides intra-partition parallelism for creating partition-wiselocal indexes.
DBMS_PIPE	Provides a DBMS pipe service which enables messages to be sentbetween sessions.
DBMS_PREDICTIVE_ANALYTICS	Automates the data mining process from data preprocessingthrough model building to scoring new data.
DBMS_PREPROCESSOR	Provides an interface to print or retrieve the source text of aPL/SQL unit in its post-processed form.
DBMS_PROFILER	Provides a Probe Profiler API to profile existing PL/SQLapplications and identify performance bottlenecks.
DBMS_PROPAGATION_ADM	Provides administrative procedures for configuring propagationfrom a source queue to a destination queue.
DBMS_RANDOM	Provides a built-in random number generator.
DBMS_RECTIFIER_DIFF	Provides APIs used to detect and resolve data inconsistenciesbetween two replicated sites.
DBMS_REDEFINITION	Lets you perform an online reorganization of tables.
DBMS_REFRESH	Lets you create groups of snapshots that can be refreshedtogether to a transactionally consistent point in time. Requiresthe Distributed Option.
DBMS_REPAIR	Provides data corruption repair procedures.
DBMS_REPCAT	Provides routines to administer and update the replicationcatalog and environment. Requires the Replication Option.
DBMS_REPCAT_ADMIN	Lets you create users with the privileges needed by thesymmetric replication facility. Requires the ReplicationOption.
DBMS_REPCAT_INSTATIATE	Instantiates deployment templates. Requires the ReplicationOption.
DBMS_REPCAT_RGT	Controls the maintenance and definition of refresh grouptemplates. Requires the Replication Option.
DBMS_REPUTIL	Provides routines to generate shadow tables, triggers, andpackages for table replication.
DBMS_RESOURCE_MANAGER	Maintains plans, consumer groups, and plan directives; it alsoprovides semantics so that you may group together changes to theplan schema.
DBMS_RESOURCE_MANAGER_PRIVS	Maintains privileges associated with resource consumergroups.
DBMS_RESUMABLE	Lets you suspend large operations that run out of space or reachspace limits after executing for a long time, fix the problem, andmake the statement resume execution.
DBMS_RLMGR	Contains various procedures to create and manage rules and rulesessions by the Rules Manager.
DBMS_RLS	Provides row level security administrative interface.
DBMS_ROWID	Provides procedures to create rowids and to interpret theircontents.
DBMS_RULE	Describes the EVALUATE procedure used inStreams.
DBMS_RULE_ADM	Describes the administrative interface for creating and managingrules, rule sets, and rule evaluation contexts; used inStreams.
DBMS_SCHEDULER	Provides a collection of scheduling functions that are callablefrom any PL/SQL program.
DBMS_SERVER_ALERT	Lets you issue alerts when some threshold has been violated.
DBMS_SERVICE	Lets you create, delete, activate and deactivate services for asingle instance.
DBMS_SESSION	Provides access to SQL ALTER SESSIONstatements, and other session information, from storedprocedures.
DBMS_SHARED_POOL	Lets you keep objects in shared memory, so that they will not beaged out with the normal LRU mechanism.
DBMS_SPACE	Provides segment space information not available throughstandard SQL.
DBMS_SPACE_ADMIN	Provides tablespace and segment space administration notavailable through the standard SQL.
DBMS_SQL	Lets you use dynamic SQL to access the database.
DBMS_SQLTUNE	Provides the interface to tune SQL statements.
DBMS_STAT_FUNCS	Provides statistical functions.
DBMS_STATS	Provides a mechanism for users to view and modify optimizerstatistics gathered for database objects.
DBMS_STORAGE_MAP	Communicates with FMON to invoke mapping operations.
DBMS_STREAMS	Describes the interface to convert SYS.AnyDataobjects into LCR objects and an interface to annotate redo entriesgenerated by a session with a binary tag.
DBMS_STREAMS_ADMIN	Describes administrative procedures for adding and removingsimple rules, without transformations, for capture, propagation,and apply at the table, schema, and database level.
DBMS_STREAMS_AUTH	Provides interfaces for granting privileges to Streamsadministrators and revoking privileges from Streamsadministrators.
DBMS_STREAMS_MESSAGING	Provides interfaces to enqueue messages into and dequeuemessages from a SYS.AnyData queue.
DBMS_STREAMS_TABLESPACE_ADM	Provides administrative procedures for copying tablespacesbetween databases and moving tablespaces from one database toanother.
DBMS_TRACE	Provides routines to start and stop PL/SQL tracing.
DBMS_TRANSACTION	Provides access to SQL transaction statements from storedprocedures and monitors transaction activities.
DBMS_TRANSFORM	Provides an interface to the message format transformationfeatures of Oracle Advanced Queuing.
DBMS_TDB	Reports whether a database can be transported between platformsusing the RMAN CONVERT DATABASE command. It verifiesthat databases on the current host platform are of the same endianformat as the destination platform, and that the state of thecurrent database does not prevent transport of the database.
DBMS_TTS	Checks if the transportable set is self-contained.
DBMS_TYPES	Consists of constants, which represent the built-in anduser-defined types.
DBMS_UTILITY	Provides various utility routines.
DBMS_WARNING	Provides the interface to query, modify and delete currentsystem or session settings.
DBMS_WORKLOAD_REPOSITORY	lets you manage the Workload Repository, performing operationssuch as managing snapshots and baselines.
DBMS_WM	Describes how to use the programming interface to OracleDatabase Workspace Manager to work with long transactions.
DBMS_XDB	Describes Resource Management and Access Control APIs forPL/SQL
DBMS_XDB_VERSION	Describes versioning APIs
DBMS_XDBT	Describes how an administrator can create a ConText index on theXML DB hierarchy and configure it for automatic maintenance
DBMS_XDBZ	Controls the Oracle XML DB repository security, which is basedon Access Control Lists (ACLs).
DBMS_XMLDOM	Explains access to XMLType objects
DBMS_XMLGEN	Converts the results of a SQL query to a canonical XMLformat.
DBMS_XMLPARSER	Explains access to the contents and structure of XMLdocuments.
DMBS_XMLQUERY	Provides database-to-XMLType functionality.
DBMS_XMLSAVE	Provides XML-to-database-type functionality.
DBMS_XMLSCHEMA	Explains procedures to register and delete XML schemas.
DBMS_XMLSTORE	Provides the ability to store XML data in relational tables.
DBMS_XPLAN	Describes how to format the output of the EXPLAINPLAN command.
DBMS_XSLPROCESSOR	Explains access to the contents and structure of XMLdocuments.
DEBUG_EXTPROC	Lets you debug external procedures on platforms with debuggersthat attach to a running process.
HTF	Hypertext functions generate HTML tags.
HTMLDB_APPLICATION	Enables users to take advantage of global variables
HTMLDB_CUSTOM_AUTH	Enables users to create form elements dynamically based on a SQLquery instead of creating individual items page by page.
HTMLDB_ITEM	Enables users to create form elements dynamically based on a SQLquery instead of creating individual items page by page.
HTMLDB_UTIL	Provides utilities for getting and setting session state,getting files, checking authorizations for users, resettingdifferent states for users, and also getting and settingpreferences for users.
HTP	Hypertext procedures generate HTML tags.
OWA_CACHE	Provides an interface that enables the PL/SQLGateway cache to improve the performance of PL/SQL webapplications.
OWA_COOKIE	Provides an interface for sending and retrieving HTTP cookiesfrom the client's browser.
OWA_CUSTOM	Provides a Global PLSQL Agent Authorization callbackfunction
OWA_IMAGE	Provides an interface to access the coordinates where a userclicked on an image.
OWA_OPT_LOCK	Contains subprograms that impose optimistic locking strategiesso as to prevent lost updates.
OWA_PATTERN	Provides an interface to locate text patterns within strings andreplace the matched string with another string.
OWA_SEC	Provides an interface for custom authentication.
OWA_TEXT	Contains subprograms used by OWA_PATTERN formanipulating strings. They are externalized so you can use themdirectly.
OWA_UTIL	Contains utility subprograms for performing operations such asgetting the value of CGI environment variables, printing the datathat is returned to the client, and printing the results of a queryin an HTML table.
SDO_CS	Provides functions for coordinate system transformation.
SDO_GCDR	Contains the Oracle Spatial geocoding subprograms, which let yougeocode unformatted postal addresses.
SDO_GEOM	Provides functions implementing geometric operations on spatialobjects.
SDO_GEOR	Contains functions and procedures for the Spatial GeoRasterfeature, which lets you store, index, query, analyze, and deliverraster image data and its associated Spatial vector geometry dataand metadata.
SDO_GEOR_UTL	Contains utility functions and procedures for the SpatialGeoRaster feature, including those related to using triggers withGeoRaster data.
SDO_LRS	Provides functions for linear referencing system support.
SDO_MIGRATE	Provides functions for migrating spatial data from previousreleases.
SDO_NET	Provides functions and procedures for working with data modeledas nodes and links in a network.
SDO_NET_MEM	Contains functions and procedures for performing editing andanalysis operations on network data using a network memoryobject
SDO_SAM	Contains functions and procedures for spatial analysis and datamining.
SDO_TOPO	Provides procedures for creating and managing Spatialtopologies.
SDO_TOPO_MAP	Contains subprograms for editing Spatial topologies using acache (TopoMap object).
SDO_TUNE	Provides functions for selecting parameters that determine thebehavior of the spatial indexing scheme used in Oracle Spatial.
SDO_UTIL	Provides utility functions and procedures for OracleSpatial.
UTL_COLL	Enables PL/SQL programs to use collection locators to query andupdate.
UTL_COMPRESS	Provides a set of data compression utilities.
UTL_DBWS	Provides database web services.
UTL_ENCODE	Provides functions that encode RAW data into a standard encodedformat so that the data can be transported between hosts.
UTL_FILE	Enables your PL/SQL programs to read and write operating systemtext files and provides a restricted version of standard operatingsystem stream file I/O.
UTL_HTTP	Enables HTTP callouts from PL/SQL and SQL to access data on theInternet or to call Oracle Web Server Cartridges.
UTL_I18N	Provides a set of services (Oracle Globalization Service) thathelp developers build multilingual applications.
UTL_INADDR	Provides a procedure to support internet addressing.
UTL_LMS	Retrieves and formats error messages in different languages.
UTL_MAIL	A utility for managing email which includes commonly used emailfeatures, such as attachments, CC, BCC, and return receipt.
UTL_NLA	Exposes a subset of the BLAS and LAPACK (Version 3.0) operationson vectors and matrices represented as VARRAYs
UTL_RAW	Provides SQL functions for RAW datatypes thatconcat, substr to and from RAWS.
UTL_RECOMP	Recompiles invalid PL/SQL modules, Java classes, indextypes andoperators in a database, either sequentially or in parallel.
UTL_REF	Enables a PL/SQL program to access an object by providing areference to the object.
UTL_SMTP	Provides PL/SQL functionality to send emails.
UTL_TCP	Provides PL/SQL functionality to support simple TCP/IP-basedcommunications between servers and the outside world.
UTL_URL	Provides escape and mechanisms for URL characters.
WPG_DOCLOAD	Provides an interface to download files, both BLOBs andBFILEs
ANYDATA TYPE	A self-describing data instance type containing an instance ofthe type plus a description
ANYDATASET TYPE	Contains a description of a given type plus a set of datainstances of that type
ANYTYPE TYPE	Contains a type description of any persistent SQL type, named orunnamed, including object types and collection types; or, it can beused to construct new transient type descriptions
Oracle Streams AQ Types	Describes the types used in Advanced Queuing
Database URI Type	Contains URI Support, UriType Super Type, HttpUriType Subtype,DBUriType Subtype, XDBUriType Subtype, UriFactory Package
JMS TYPES	Describes JMS types so that a PL/SQL application can use JMSqueues of JMS types
LOGICAL CHANGE RECORD TYPES	Describes LCR types, which are message payloads that containinformation about changes to a database, used in Streams
interMedia ORDAudio Type	Supports the storage and management of audio data.
interMedia ORDDoc Type	Supports the storage and management of heterogeneous media dataincluding image, audio, and video.
interMedia ORDImage Type	Supports the storage, management, and manipulation of imagedata.
interMedia ORDImageSignature Type	Supports content-based retrieval of images (image matching).
interMedia SQL/MM Still Image Type	Provides support for the SQL/MM Still Image Standard, which letsyou store, retrieve, and modify images in the database and locateimages using visual predicates.
interMedia ORDVideo Type	Supports the storage and management of video data.
RULES TYPES	Describes the types used with rules, rule sets, and evaluationcontexts
XMLType	Describes the types and functions used for native XML support inthe server