Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 93 of 521
ALL_STORED_SETTINGS
provides information about the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges.
DBA_STORED_SETTINGS
lists information about the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges. It also returns parameter information for all objects in the database and is accessible only to users with the SELECT_CATALOG_ROLE
privilege.
USER_STORED_SETTINGS
lists information about the persistent parameter settings for stored PL/SQL units, but only shows information about PL/SQL units owned by the current user. This view does not display the OWNER
column.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|