[Home] [Help] [Dependency Information]
Object Name: | ALL_STORED_SETTINGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Parameter settings for objects accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Username of the owner of the object |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the object |
OBJECT_ID | NUMBER | Yes | Object number of the object | |
OBJECT_TYPE | VARCHAR2 | (12) | Type of the object | |
PARAM_NAME | VARCHAR2 | (128) | Yes | Name of the parameter |
PARAM_VALUE | VARCHAR2 | (4000) | Value of the parameter | |
ORIGIN_CON_ID | NUMBER | ID of Container where row originates |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, OBJECT_ID
, OBJECT_TYPE
, PARAM_NAME
, PARAM_VALUE
, ORIGIN_CON_ID
FROM SYS.ALL_STORED_SETTINGS;
|
|
|