إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

ممكن شرح Oracle Supplied


1 رد (ردود) على هذا الموضوع

#1 abdu1_far

abdu1_far

    عضو نشط

  • الأعضــاء
  • 430 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 17 May 2007 - 02:12 PM

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

#2 عبداللطيف

عبداللطيف

    مــشــرف عــام

  • الإشراف العام
  • 1,267 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 17 May 2007 - 03:04 PM


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.e...68001/intro.htm


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



أ رواجع هذا الرابط
http://www.araboug.o...p?showtopic=296