在PLSQL SELECT语句中使用变量

我有一个查询ReportStartDate和ReportEndDate的查询,以是我想我会在PLSQL中行使变量.不知道我在这里穷乏什么,但我收到一个错误：

CLEAR;
DECLARE
    varReportStartDate Date := to_date('05/01/2010','mm/dd/yyyy');
    varReportEndDate Date := to_date('05/31/2010','mm/dd/yyyy');
BEGIN

    SELECT 
          'Value TYPE',1 AS CountType1,2 AS CountType2,3 AS CountType3 
    FROM DUAL;

    SELECT COUNT (*) 
    FROM CDR.MSRS_E_INADVCH

    WHERE 1=1
    AND ReportStartDate = varReportStartDate 
    AND ReportEndDate = varReportEndDate 
    ;
END;
/

错误是：

Error starting at line 2 in command:
Error report:
ORA-06550: line 6,column 5:
PLS-00428: an INTO clause is expected in this SELECT statement
ORA-06550: line 8,column 5:
PLS-00428: an INTO clause is expected in this SELECT statement
06550. 00000 -  "line %s,column %s:n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

这种环境产生在Toad以及SQL Developer中.

在WHERE子句中行使变量的正确要领是什么？

办理要领

SELECT 
      'Value TYPE',3 AS CountType3 
INTO 
     V_VALUE_TYPE,V_CountType1,V_CountType2,V_CountType3
FROM DUAL;

SELECT COUNT(*) 
   INTO V_COUNT    
FROM CDR.MSRS_E_INADVCH
WHERE 1=1
AND ReportStartDate = varReportStartDate 
AND ReportEndDate = varReportEndDate

必然要添加非常处理赏罚措施,由于PL / SQL只必要返回1行.假如语句没有返回任何行,则会碰着NO_DATA_FOUND非常 – 假如语句获取太多行,则会碰着TOO_MANY_ROWS非常.

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!