ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_MVIEW_AGGREGATES: Description of the materialized view
aggregates accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_AGGREGATES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
AGG_FUNCTION
VARCHAR2(8)
DISTINCTFLAG
VARCHAR2(1)
MEASURE
LONG
ALL_MVIEW_ANALYSIS: Description of the materialized views accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_ANALYSIS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
MVIEW_TABLE_OWNER
NOT NULL VARCHAR2(30)
CONTAINER_NAME
VARCHAR2(30)
LAST_REFRESH_SCN
NUMBER
LAST_REFRESH_DATE
DATE
REFRESH_METHOD
VARCHAR2(8)
SUMMARY
VARCHAR2(1)
FULLREFRESHTIM
NUMBER
INCREFRESHTIM
NUMBER
CONTAINS_VIEWS
VARCHAR2(1)
UNUSABLE
VARCHAR2(1)
RESTRICTED_SYNTAX
VARCHAR2(1)
INC_REFRESHABLE
VARCHAR2(1)
KNOWN_STALE
VARCHAR2(1)
INVALID
VARCHAR2(1)
REWRITE_ENABLED
VARCHAR2(1)
QUERY_LEN
NUMBER
QUERY
LONG
REVISION
NOT NULL NUMBER
ALL_MVIEW_COMMENTS: Comments on materialized views
accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_MVIEW_DETAIL_RELATIONS: Description of the materialized view
detail tables accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_DETAIL_RELATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT
NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(9)
DETAILOBJ_ALIAS
VARCHAR2(30)
ALL_MVIEW_JOINS: Description of a join between two
columns in the WHERE clause of a materialized view accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_JOINS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ1_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ1_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ1_COLUMN
NOT NULL VARCHAR2(30)
OPERATOR
CHAR(1)
OPERATOR_TYPE
VARCHAR2(1)
DETAILOBJ2_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ2_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ2_COLUMN
NOT NULL VARCHAR2(30)
ALL_MVIEW_KEYS: Description of the columns that appear
in the GROUP BY list of a materialized view accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_KEYS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_ALIAS
VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(5)
DETAILOBJ_COLUMN
NOT NULL VARCHAR2(30)
ALL_MVIEW_LOGS: All materialized view logs in the
database that the user can see
iSelfSchooling-SQL> desc ALL_MVIEW_LOGS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LOG_TABLE
VARCHAR2(30)
LOG_TRIGGER
VARCHAR2(30)
ROWIDS
VARCHAR2(3)
PRIMARY_KEY
VARCHAR2(3)
OBJECT_ID
VARCHAR2(3)
FILTER_COLUMNS
VARCHAR2(3)
SEQUENCE
VARCHAR2(3)
INCLUDE_NEW_VALUES
VARCHAR2(3)
ALL_MVIEW_REFRESH_TIMES: Materialized views and their last
refresh times for each master table that the user can look at
iSelfSchooling-SQL> desc ALL_MVIEW_REFRESH_TIMES;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LAST_REFRESH
DATE
ALL_NESTED_TABLES: Description of nested tables in tables
accessible to the user
iSelfSchooling-SQL> desc ALL_NESTED_TABLES;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE_NAME
VARCHAR2(30)
PARENT_TABLE_NAME
VARCHAR2(30)
PARENT_TABLE_COLUMN
VARCHAR2(4000)
STORAGE_SPEC
VARCHAR2(30)
RETURN_TYPE
VARCHAR2(20)
ELEMENT_SUBSTITUTABLE
VARCHAR2(25)
ALL_NESTED_TABLE_COLS: Columns of nested tables
iSelfSchooling-SQL> desc ALL_NESTED_TABLE_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_TYPE_MOD
VARCHAR2(3)
DATA_TYPE_OWNER
VARCHAR2(30)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
COLUMN_ID
NUMBER
DEFAULT_LENGTH
NUMBER
DATA_DEFAULT
LONG
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
LAST_ANALYZED
DATE
SAMPLE_SIZE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
CHAR_COL_DECL_LENGTH
NUMBER
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
V80_FMT_IMAGE
VARCHAR2(3)
DATA_UPGRADED
VARCHAR2(3)
HIDDEN_COLUMN
VARCHAR2(3)
VIRTUAL_COLUMN
VARCHAR2(3)
SEGMENT_COLUMN_ID
NUMBER
INTERNAL_COLUMN_ID
NOT NULL NUMBER
HISTOGRAM
VARCHAR2(15)
QUALIFIED_COL_NAME
VARCHAR2(4000)
ALL_OBJECTS: Objects accessible to the user
iSelfSchooling-SQL> desc ALL_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
DATA_OBJECT_ID
NUMBER
OBJECT_TYPE
VARCHAR2(19)
CREATED
NOT NULL DATE
LAST_DDL_TIME
NOT NULL DATE
TIMESTAMP
VARCHAR2(19)
STATUS
VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
ALL_OBJECT_TABLES: Description of all object tables
accessible to the user
iSelfSchooling-SQL> desc ALL_OBJECT_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
OBJECT_ID_TYPE
VARCHAR2(16)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE
VARCHAR2(30)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
ALL_OBJ_COLATTRS: Description of object columns and
attributes contained in the tables accessible to the user
iSelfSchooling-SQL> desc ALL_OBJ_COLATTRS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
SUBSTITUTABLE
VARCHAR2(15)
ALL_OLAP_ALTER_SESSION: Synonym for V$OLAP_ALTER_SESSION
iSelfSchooling-SQL> desc ALL_OLAP_ALTER_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
ROLE
NOT NULL VARCHAR2(30)
CLAUSE_TEXT
VARCHAR2(3000)
ALL_OPANCILLARY: All ancillary operators available to
the user
iSelfSchooling-SQL> desc ALL_OPANCILLARY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
PRIMOP_OWNER
NOT NULL VARCHAR2(30)
PRIMOP_NAME
NOT NULL VARCHAR2(30)
PRIMOP_BIND#
NOT NULL NUMBER
ALL_OPARGUMENTS: All arguments of the operators available to the user
iSelfSchooling-SQL> desc ALL_OPARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
POSITION
NOT NULL NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
ALL_OPBINDINGS: All binding functions for operators
available to the user
iSelfSchooling-SQL> desc ALL_OPBINDINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
FUNCTION_NAME
VARCHAR2(92)
RETURN_SCHEMA
VARCHAR2(30)
RETURN_TYPE
VARCHAR2(30)
IMPLEMENTATION_TYPE_SCHEMA VARCHAR2(30)
IMPLEMENTATION_TYPE
VARCHAR2(30)
PROPERTY
VARCHAR2(43)
ALL_OPERATORS: All operators available to the user
iSelfSchooling-SQL> desc ALL_OPERATORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
NUMBER_OF_BINDS
NOT NULL NUMBER
ALL_OPERATOR_COMMENTS: Comments for user-defined operators
iSelfSchooling-SQL> desc ALL_OPERATOR_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_OUTLINES: Synonym for USER_OUTLINES
iSelfSchooling-SQL> desc ALL_OUTLINES;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
CATEGORY
VARCHAR2(30)
USED
VARCHAR2(6)
TIMESTAMP
DATE
VERSION
VARCHAR2(64)
SQL_TEXT
LONG
SIGNATURE
RAW(16)
COMPATIBLE
VARCHAR2(12)
ENABLED
VARCHAR2(8)
FORMAT
VARCHAR2(6)
ALL_OUTLINE_HINTS: Synonym for USER_OUTLINE_HINTS
iSelfSchooling-SQL> desc ALL_OUTLINE_HINTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
NODE
NUMBER
STAGE
NUMBER
JOIN_POS
NUMBER
HINT
CLOB
ALL_PARTIAL_DROP_TABS: All tables with patially dropped
columns accessible to the user
iSelfSchooling-SQL> desc ALL_PARTIAL_DROP_TABS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
ALL_PART_COL_STATISTICS
iSelfSchooling-SQL> desc ALL_PART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
ALL_PART_HISTOGRAMS
iSelfSchooling-SQL> desc ALL_PART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
ALL_PART_INDEXES
iSelfSchooling-SQL> desc ALL_PART_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NOT NULL NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NOT NULL NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
LOCALITY
VARCHAR2(6)
ALIGNMENT
VARCHAR2(12)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NOT NULL NUMBER
DEF_INI_TRANS
NOT NULL NUMBER
DEF_MAX_TRANS
NOT NULL NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NOT NULL NUMBER
DEF_FREELIST_GROUPS
NOT NULL NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
DEF_PARAMETERS
VARCHAR2(1000)
ALL_PART_KEY_COLUMNS
iSelfSchooling-SQL> desc ALL_PART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
ALL_PART_LOBS
iSelfSchooling-SQL> desc ALL_PART_LOBS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_INDEX_NAME
NOT NULL VARCHAR2(30)
DEF_CHUNK
NOT NULL NUMBER
DEF_PCTVERSION
NOT NULL NUMBER
DEF_CACHE
VARCHAR2(10)
DEF_IN_ROW
VARCHAR2(3)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
VARCHAR2(40)
DEF_FREELIST_GROUPS
VARCHAR2(40)
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
ALL_PART_TABLES
iSelfSchooling-SQL> desc ALL_PART_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
STATUS
VARCHAR2(8)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NUMBER
DEF_PCT_USED
NUMBER
DEF_INI_TRANS
NUMBER
DEF_MAX_TRANS
NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NUMBER
DEF_FREELIST_GROUPS
NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_COMPRESSION
VARCHAR2(8)
DEF_BUFFER_POOL
VARCHAR2(7)
ALL_PENDING_CONV_TABLES: All tables accessible to the user which
are not upgraded to the latest type version
iSelfSchooling-SQL> desc ALL_PENDING_CONV_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
ALL_PLSQL_OBJECT_SETTINGS: Compiler settings of stored objects accessible to the user
iSelfSchooling-SQL> desc ALL_PLSQL_OBJECT_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
PLSQL_OPTIMIZE_LEVEL
NUMBER
PLSQL_CODE_TYPE
VARCHAR2(4000)
PLSQL_DEBUG
VARCHAR2(4000)
PLSQL_WARNINGS
VARCHAR2(4000)
NLS_LENGTH_SEMANTICS
VARCHAR2(4000)
PLSQL_CCFLAGS
VARCHAR2(4000)
ALL_POLICIES: All policies for objects if the user
has system privileges or owns the objects
iSelfSchooling-SQL> desc ALL_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
POLICY_GROUP
VARCHAR2(30)
POLICY_NAME
VARCHAR2(30)
PF_OWNER
VARCHAR2(30)
PACKAGE
VARCHAR2(30)
FUNCTION
VARCHAR2(30)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
IDX
VARCHAR2(3)
CHK_OPTION
VARCHAR2(3)
ENABLE
VARCHAR2(3)
STATIC_POLICY
VARCHAR2(3)
POLICY_TYPE
VARCHAR2(24)
LONG_PREDICATE
VARCHAR2(3)
ALL_POLICY_CONTEXTS: All policy driving context defined for
all synonyms, tables, or views accessable to the user
iSelfSchooling-SQL> desc ALL_POLICY_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
NAMESPACE
VARCHAR2(30)
ATTRIBUTE
VARCHAR2(30)
ALL_POLICY_GROUPS: All policy groups defined for any
synonym, table or view accessable to the user
iSelfSchooling-SQL> desc ALL_POLICY_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
POLICY_GROUP
VARCHAR2(30)
|