в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:07:52Z

1 версия

Новая страница

== Query all_objects for all packages and package bodies==



<source lang="sql">
SQL>
SQL>
SQL> SELECT object_name, object_type
2 FROM all_objects
3 WHERE owner = "SYS"
4 AND object_type IN ("PACKAGE", "PACKAGE BODY")
5 and rownum < 50
6 ORDER BY object_name, object_type;
DBMS_ADVISOR PACKAGE
DBMS_JAVA_TEST PACKAGE
DBMS_JAVA_TEST PACKAGE BODY
DBMS_LOB PACKAGE
DBMS_LOB PACKAGE BODY
DBMS_PICKLER PACKAGE
DBMS_PICKLER PACKAGE BODY
DBMS_REGISTRY PACKAGE
DBMS_REGISTRY PACKAGE BODY
DBMS_REGISTRY_SERVER PACKAGE
DBMS_STANDARD PACKAGE
DIANA PACKAGE
DIANA PACKAGE BODY
DIUTIL PACKAGE
DIUTIL PACKAGE BODY
PIDL PACKAGE
PIDL PACKAGE BODY
PLITBLM PACKAGE
STANDARD PACKAGE
STANDARD PACKAGE BODY
SYS_STUB_FOR_PURITY_ANALY PACKAGE
SIS
UTL_COMPRESS PACKAGE
UTL_COMPRESS PACKAGE BODY
UTL_ENCODE PACKAGE
UTL_ENCODE PACKAGE BODY
UTL_FILE PACKAGE
UTL_FILE PACKAGE BODY
UTL_GDK PACKAGE
UTL_GDK PACKAGE BODY
UTL_HTTP PACKAGE
UTL_HTTP PACKAGE BODY
UTL_I18N PACKAGE
UTL_I18N PACKAGE BODY
UTL_INADDR PACKAGE
UTL_INADDR PACKAGE BODY
UTL_LMS PACKAGE
UTL_LMS PACKAGE BODY
UTL_RAW PACKAGE
UTL_RAW PACKAGE BODY
UTL_SMTP PACKAGE
UTL_SMTP PACKAGE BODY
UTL_SYS_COMPRESS PACKAGE
UTL_SYS_COMPRESS PACKAGE BODY
UTL_TCP PACKAGE
UTL_TCP PACKAGE BODY
UTL_URL PACKAGE
UTL_URL PACKAGE BODY
XML_SCHEMA_NAME_PRESENT PACKAGE
XML_SCHEMA_NAME_PRESENT PACKAGE BODY
49 rows selected.
SQL></source>

== Query all_objects table by object_id==



<source lang="sql">
SQL>
SQL> select owner, object_name
2 from all_objects
3 where object_id = 2408;
OWNER OBJECT_NAME
------------------------------ ------------------------------
PUBLIC DBA_SYS_PRIVS
SQL></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/System Tables Data Dictionary/all objects - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия