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

Term: USER_REPFLAVOR_COLUMNS

Definition:
In Oracle, the USER_REPFLAVOR_COLUMNS dictionary view maintains the replicating columns in the flavors from the tables which are owned by the current user. The structure of the view is shown below.

FNAME [VARCHAR2(30)] - Flavor Name
GNAME [VARCHAR2(30)] - Object group name
SNAME [VARCHAR2(30)] - Schema name containing the object group
ONAME [VARCHAR2(30)] - Object Name
CNAME [VARCHAR2(4000)] - Column Name
TYPE [VARCHAR2(30)] - Column Data type
POS [NUMBER] - Column sequence in the parameter list in replication procedures
GROUP_OWNER [VARCHAR2(30)] - Object group owner
TYPE_TOID [RAW(16)] - Type OID of a column of type
TYPE_OWNER [VARCHAR2(30)] - Type Owner of a column of type
TYPE_HASHCODE [VARCHAR2(34)] - Type hashcode of a column of TYPE
TYPE_MOD [VARCHAR2(3)] - Datatype modifier of a column
TOP [VARCHAR2(30)] - Top column of this attribute column

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