SNAME
|
VARCHAR2(30)
|
NOT NULL
|
The name of the object owner. |
ONAME
|
VARCHAR2(30)
|
NOT NULL
|
The name of the object. |
TYPE
|
VARCHAR2(8)
|
- |
The type of the object, either MATERIALIZED VIEW or TABLE . |
CNAME
|
VARCHAR2(4000)
|
- |
The name of the replicated column. |
ID
|
NUMBER
|
- |
The ID number of the replicated column. |
POS
|
NUMBER
|
- |
The ordering of the replicated column. |
COMPARE_OLD_ON_DELETE
|
VARCHAR2(1)
|
- |
Indicates whether Oracle compares the old value of the column in replicated deletes. |
COMPARE_OLD_ON_UPDATE
|
VARCHAR2(1)
|
- |
Indicates whether Oracle compares the old value of the column in replicated updates. |
SEND_OLD_ON_DELETE
|
VARCHAR2(1)
|
- |
Indicates whether Oracle sends the old value of the column in replicated deletes. |
SEND_OLD_ON_UPDATE
|
VARCHAR2(1)
|
- |
Indicates whether Oracle sends the old value of the column in replicated updates. |
CTYPE
|
VARCHAR2(30)
|
- |
Displays the column type. For user-defined types, displays the user-defined type name. |
CTYPE_TOID
|
RAW(16)
|
- |
If user-defined type, displays the object identifier (OID) of the type. Otherwise, this field is NULL . |
CTYPE_OWNER
|
VARCHAR2(30)
|
- |
If user-defined type, displays the owner of a user-defined type. Otherwise, this field is NULL . |
CTYPE_HASHCODE
|
VARCHAR2(34)
|
- |
If user-defined type, displays the type's hashcode. Otherwise, this field is NULL . |
CTYPE_MOD
|
VARCHAR2(3)
|
- |
Displays REF for REF columns. Otherwise, this field is NULL . |
DATA_LENGTH
|
VARCHAR2(40)
|
- |
Displays the length of the column in bytes. |
DATA_PRECISION
|
VARCHAR2(40)
|
- |
Displays the column precision in terms of decimal digits for NUMBER columns or binary digits for FLOAT columns. |
DATA_SCALE
|
VARCHAR2(40)
|
- |
Displays the digits to right of decimal point in a number. |
NULLABLE
|
VARCHAR2(1)
|
- |
Indicates if the column allow NULL values. |
CHARACTER_SET_NAME
|
VARCHAR2(44)
|
- |
If applicable, displays the name of character set for the column. |
TOP
|
VARCHAR2(30)
|
- |
Displays the top column for an attribute in a column object. For example, in the oe.customers table, cust_address is a column object and street_address is one of its attributes. For the street_address attribute, cust_address is the TOP column.
For built-in datatypes, this field is NULL |
CHAR_LENGTH
|
NUMBER
|
- |
Displays the length of the column in characters. This value only applies to the following datatypes:
CHAR
VARCHAR2
NCHAR
NVARCHAR2 |
CHAR_USED
|
VARCHAR2(1)
|
- |
B indicates that the column uses BYTE length semantics. C indicates that the column uses CHAR length semantics. NULL indicates that the datatype is not any of the following:
CHAR
VARCHAR2
NCHAR
NVARCHAR2 |