Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL USER_REPCOLUMN View      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: USER_REPCOLUMN

Definition:
In Oracle, the USER_REPCOLUMN view contains the replicated columns for the tables which are owned by the current user. For an object type column, the view stores the attribute information. For columns of nested table type, the view stores the storage table details.

The structure of the view is shown below.

SNAME [VARCHAR2 (30)] - Object owner
ONAME [VARCHAR2 (30)] - Object name
TYPE [VARCHAR2 (8)] - Object type
CNAME [VARCHAR2 (4000)] - Replicated column name
ID [NUMBER (22)] - Replicated column ID
POS [NUMBER (22)] - Replicated column order
COMPARE_OLD_ON_DELETE [VARCHAR2 (1)] - Compare the old value of the column in replicated deletes
COMPARE_OLD_ON_UPDATE [VARCHAR2 (1)] - Compare the old value of the column in replicated updates
SEND_OLD_ON_DELETE [VARCHAR2 (1)] - Send the old value of the column in replicated deletes
SEND_OLD_ON_UPDATE [VARCHAR2 (1)] - Send the old value of the column in replicated updates
CTYPE [VARCHAR2 (106)] - Column Type
CTYPE_TOID [RAW (16)] - Type OID of a column of TYPE
CTYPE_OWNER [VARCHAR2 (30)] - Type owner of a column of TYPE
CTYPE_HASHCODE [VARCHAR2 (34)] - Type hashcode of a column of TYPE
CTYPE_MOD [VARCHAR2 (3)] - Datatype modifier of a column
DATA_LENGTH [VARCHAR2 (40)] - Column Length in bytes
DATA_PRECISION [VARCHAR2 (40)] - Column precision
DATA_SCALE [VARCHAR2 (40)] - Decimal precision
NULLABLE [VARCHAR2 (1)] - NULL property of a column
CHARACTER_SET_NAME [VARCHAR2 (44)] - Character set for the column
TOP [VARCHAR2 (30)] - Top column name for an attribute
CHAR_LENGTH [NUMBER (22)] - Maximum length of character column
CHAR_USED [VARCHAR2 (1)] - C if the width was specified in characters, B if in bytes

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 57 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?