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

Term: ALL_REPPRIORITY

Definition:
In Oracle PL/SQL, the ALL_REPPRIORITY dictionary view displays the unique combination of value and priority for a member within an accessible priority group. Note that priority groups have unique names within a replication group.

The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the replicating group
PRIORITY_GROUP [VARCHAR2(30)] - Priority group name
PRIORITY [NUMBER] - Priority level of the member within the group
DATA_TYPE [VARCHAR2(9)] - Data type of the member
FIXED_DATA_LENGTH [NUMBER(38)] - Precision of the value
CHAR_VALUE [CHAR(255)] - Priority group member value [CHAR]
VARCHAR2_VALUE [VARCHAR2(4000)] - Priority group member value [VARCHAR2]
NUMBER_VALUE [NUMBER] - Priority group member value [NUMBER]
DATE_VALUE [DATE] - Priority group member value [DATE]
RAW_VALUE [RAW(2000)] - Priority group member value [RAW]
GNAME [VARCHAR2(30)] - Replication group name
NCHAR_VALUE [NCHAR(500)] - Priority group member value [NCHAR]
NVARCHAR2_VALUE [NVARCHAR2(1000)] - Priority group member value [NVARCHAR2]
LARGE_CHAR_VALUE [CHAR(2000)] - Priority group member value [CHAR value exceeding 255 characters]

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