ممكن شرح Oracle Supplied

[abdu1_far]

اخواني الاعزاء ، انا كنت قرأت عن الاوراكل سبلايد ، بس للاسف مافهمتش أيه وظيفتها وازاي استخدمها ، انا عارف انها عبارة عن بكتج تم انشائها من قبل بواسطة اوراكل ، بس مش عارف ايه فايدتها وازاي استخدمها
فلو تكرمتوا لو حد يشرحه لي بأسلوب بسيط كده وياريت أمثلة
وجزاكم الله خيراً

[عبداللطيف]

Oracle Supplied Packages

Package Description

DBMS_ALERT Notify a database event (asynchronous)

DBMS_APPLICATION_INFO
Register an application name with the database
for auditing or performance tracking.
Application info can be pushed into V$SESSION/V$SESSION_LONGOPS

DBMS_AQ Add a message (of a predefined object type) onto a queue
or dequeue a message.

DBMS_AQADM Administer a queue or queue table
for messages of a predefined object type.

DBMS_AQELM Configure Advanced Queuing
asynchronous notification by e-mail and HTTP. *

DBMS_BACKUP_RESTORE
Normalize filenames on Windows NT platforms.

DBMS_DDL Access SQL DDL statements from a stored procedure,
provides special administration operations
not available as DDLs.

DBMS_DEBUG Implement server-side debuggers and provide a way to
debug server-side PL/SQL program units.

DBMS_DEFER User interface to a replicated transactional deferred
RPC facility. Requires the Distributed Option.

DBMS_DEFER_QUERY
Permit querying the deferred remote procedure calls (RPC)
queue data that is not exposed through views.
Requires the Distributed Option.

DMBS_DEFER_SYS
The system administrator interface to a replicated
transactional deferred RPC facility.
Requires the Distributed Option.

DBMS_DESCRIBE
Describe the arguments of a stored procedure
with full name translation and security checking.

DBMS_DISTRIBUTED_TRUST_ADMIN
Maintain the Trusted Database List, which is used to
determine if a privileged database link from a particular
server can be accepted.

DBMS_ENCODE Encode???

DBMS_FGA Fine-grained security functions. *

DMBS_FLASHBACK
Flash back to a version of the database at a specified
wall-clock time or a specified system change
number (SCN). *

DBMS_HS_PASSTHROUGH
Send pass-through SQL statements to non-Oracle systems.
(via Heterogeneous Services)

DBMS_IOT Create a table into which references to the chained rows
for an Index Organized Table can be placed using the
ANALYZE command.

DBMS_JOB Schedule PL/SQL procedures that you want performed at
periodic intervals; also the job queue interface.

DBMS_LDAP Functions and procedures to access data from
LDAP servers. *

DBMS_LIBCACHE
Prepares the library cache on an Oracle instance by
extracting SQL and PL/SQL from a remote instance and
compiling this SQL locally without execution. *

DBMS_LOB General purpose routines for operations on Oracle Large
Object (LOBs) datatypes - BLOB, CLOB (read-write),
and BFILEs (read-only).

DBMS_LOCK Request, convert and release locks through Oracle Lock
Management services.

DBMS_LOGMNR Functions to initialize and run the log reader.

DBMS_LOGMNR_CDC_PUBLISH
Identify new data that has been added to, modified, or
removed from, relational tables and publish the changed
data in a form that is usable by an application. *

DBMS_LOGMNR_CDC_SUBSCRIBE
View and query the change data that was captured
and published with the DBMS_LOGMNR_CDC_PUBLISH package. *

DBMS_LOGMNR_D
Query the dictionary tables of the current database, and
create a text based file containing their contents.

DBMS_METADATA
Retrieve complete database object definitions (metadata)
from the dictionary. *

DBMS_MVIEW Refresh snapshots that are not part of the same
refresh group and purge logs. DBMS_SNAPSHOT is a synonym.

DBMS_OBFUSCATION_TOOLKIT
Procedures for Data Encryption Standards.

DBMS_ODCI Get the CPU cost of a user function based on the
elapsed time of the function. *

DBMS_OFFLINE_OG
Public APIs for offline instantiation of master groups.

DBMS_OFFLINE_SNAPSHOT
Public APIs for offline instantiation of snapshots.

DBMS_OLAP Procedures for summaries, dimensions, and query rewrites.

DBMS_ORACLE_TRACE_AGENT
Client callable interfaces to the Oracle TRACE
instrumentation within the Oracle7 Server.



أو
===========

مع الامثلة
http://www.cs.umbc.edu/help/oracle8/server...68001/intro.htm


============
.

أ رواجع هذا الرابط
http://www.araboug.org/ib/index.php?showtopic=296