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

Term: USER_REPPRIORITY

Definition:
In Oracle, the USER_REPPRIORITY dictionary view displays the unique combination of value and priority for a member within a priority group which is owned by the current user. Note that priority groups have unique names within a replication group. The structure of the view is shown below.

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 70 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?