[Home] [Help] [Dependency Information]
Object Name: | _ALL_REPCOLUMN |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Replicated top-level columns (table) sorted alphabetically in ascending order
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAME | VARCHAR2 | (128) | Name of the object owner | |
ONAME | VARCHAR2 | (128) | Name of the object | |
TYPE | NUMBER | Type of the object | ||
LONG_CNAME | VARCHAR2 | (4000) | Long column name of the replicated column | |
ID | NUMBER | ID of the replicated column | ||
POS | NUMBER | Ordering of the replicated column | ||
FLAG | RAW | (2) | Replication information about column | |
CTYPE | NUMBER | Type name of the column | ||
DATA_LENGTH | NUMBER | Length of the column in bytes | ||
DATA_PRECISION | NUMBER | Length: decimal digits (NUMBER) or binary digits (FLOAT) | ||
DATA_SCALE | NUMBER | Digits to right of decimal point in a number | ||
NULL$ | NUMBER | Does column allow NULL values? | ||
CHARSETID | NUMBER | Character set identifier | ||
CHARSETFORM | NUMBER | Character set form | ||
CNAME | VARCHAR2 | (128) | Internal column name of the replicated column | |
CTYPE_TOID | RAW | (16) | Type OID of a column of TYPE | |
CTYPE_OWNER | VARCHAR2 | (128) | Type owner of a column of TYPE | |
CTYPE_NAME | VARCHAR2 | (128) | Type name of a column of TYPE | |
CTYPE_VERSION# | NUMBER | Type version# of a column of TYPE | ||
CTYPE_HASHCODE | RAW | (17) | Type hashcode of a column of TYPE | |
TOP | VARCHAR2 | (128) | Top column of this attribute column | |
PROPERTY | RAW | (4) | Property of this column | |
CHAR_LENGTH | NUMBER | The maximum length of the column in characters |
Cut, paste (and edit) the following text to query this object:
SELECT SNAME
, ONAME
, TYPE
, LONG_CNAME
, ID
, POS
, FLAG
, CTYPE
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, NULL$
, CHARSETID
, CHARSETFORM
, CNAME
, CTYPE_TOID
, CTYPE_OWNER
, CTYPE_NAME
, CTYPE_VERSION#
, CTYPE_HASHCODE
, TOP
, PROPERTY
, CHAR_LENGTH
FROM SYS._ALL_REPCOLUMN;
SYS._ALL_REPCOLUMN is not referenced by any database object
|
|
|