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

Term: ALL_REPCAT_USER_PARM_VALUES

Definition:
In Oracle PL/SQL, the static dictionary view ALL_REPCAT_USER_PARM_VALUES maintains the template parameters for all deployment templates contained in the database, which can be accessed by the current user. The view is populated when a template, which is accessible by the current user, is instantiated.

The structure of the dictionary view is as below.

REFRESH_TEMPLATE_NAME[VARCHAR2(30)] - Deployment template name
OWNER[VARCHAR2(30)] - Deployment template owner
REFRESH_GROUP_NAME[VARCHAR2(30)] - Refresh group associated during the instantiation process.
TEMPATE_COMMENT[VARCHAR2(2000)] - User comments.
PUBLIC_TEMPLATE[VARCHAR2(1)] - Determines whether the template is public or private
PARAMETER_NAME[VARCHAR2(30)] - Parameter name
DEFAULT_PARM_VALUE[ CLOB(4000)] - Default value for the parameter.
PROMPT_STRING[ VARCHAR2(2000)] - The prompt string for the parameter.
PARM_VALUE[ CLOB(4000)] - For a user, a value can be defined for the parameter in this column
USER_NAME[VARCHAR2(30)] - Username for whom the above value (PARM_VALUE) is defined

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