today1858的专栏

<br />CREATE OR REPLACE PROCEDURE spQcJob<br />AS<br />  v_jobname NUMBER;<br />  v_date DATE;<br />  v_Count int;<br />BEGIN<br />  select count(*) into v_Count from dba_jobs where what='spOprScoreDaily;';<br />  IF v_Count>0 THEN<br />  select job into v

<br />CREATE OR REPLACE PROCEDURE spQcJob<br />AS<br />  v_jobname NUMBER;<br />  v_date DATE;<br />  v_Count int;<br />BEGIN<br />  select count(*) into v_Count from dba_jobs where what='spOprScoreDaily;';<br />  IF v_Count>0 THEN<br />  select job into v

<br />CREATE OR REPLACE PROCEDURE spQcJob<br />AS<br />  v_jobname NUMBER;<br />  v_date DATE;<br />  v_Count int;<br />BEGIN<br />  select count(*) into v_Count from dba_jobs where what='spOprScoreDaily;';<br />  IF v_Count>0 THEN<br />  select job into v