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 SNAPSHOT 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
|