DBA Data[Home] [Help]

ORACLE_OCM.MGMT_CONFIG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

   select count(*) into l_job_cnt from
	dba_scheduler_jobs WHERE job_name = job_name_in and owner ='ORACLE_OCM';
Line: 106

    select PARALLEL into l_par  from v$instance;
Line: 108

      select instance_number into l_instNum from v$instance;
Line: 207

  CURSOR l_res_cur IS select inst_id,instance_number from gv$instance;
Line: 220

  CURSOR l_res_cur IS select inst_id, instance_number from gv$instance;