这句sql语句是什么错误了。帮忙看看。谢谢

[fifidog]

SQL> select a.zjs,e.kjs,b.rlyl,c.ylly,d.hzrc,d.hzyl from (select count(jh) zjs from ly01) a,
2 (select sum(rcyl) rlyl from dba01l where rq=:rq) b,
3 (select sum(rcyl) ylly from dba01l where to_char(rq,'yyyymmdd') between to_char(:rq,'yyyymm')||
'01' and to_char(:rq,'yyyymmdd') ) c,
4 (select hzrc,hzyl from d01_1 where rq=:rq) d,
5 (select count(jh) kjs from ly02 where rq=:rq) e;


SP2-0552: Bind variable "RQ" not declared.

[hammer_shi]

try:

VARIABLE RQ NUMBER;--ADD

SQL> select a.zjs,e.kjs,b.rlyl,c.ylly,d.hzrc,d.hzyl from (select count(jh) zjs from ly01) a,
2 (select sum(rcyl) rlyl from dba01l where rq=:rq) b,
3 (select sum(rcyl) ylly from dba01l where to_char(rq,'yyyymmdd') between to_char(:rq,'yyyymm')||
'01' and to_char(:rq,'yyyymmdd') ) c,
4 (select hzrc,hzyl from d01_1 where rq=:rq) d,
5 (select count(jh) kjs from ly02 where rq=:rq) e;

[gladness]

这句sql是从哪里拷出来的？
应该是变量rq没有定义。

[shuipipi]

泥可以把SQL语句里的“:rq”改为“&rq”，然后执行SQL的时候，SQLPLUS会向泥提示输入这个变量值～

[tolywang]

好像是delphi中需要赋值的语句, 又好像是PL/SQL中的语法 , sql语句没有一点问题 , 正如楼上两位所言 , rq变量应该声明并赋值 .

[beckhambobo]

declare
v_rq dba01l.rq%type;


select a.zjs,e.kjs,b.rlyl,c.ylly,d.hzrc,d.hzyl from (select count(jh) zjs from ly01) a,
(select sum(rcyl) rlyl from dba01l where rq=v_rq) b,
(select sum(rcyl) ylly from dba01l where to_char(rq,'yyyymmdd') between to_char(v_rq,'yyyymm')||
'01' and to_char(v_rq,'yyyymmdd') ) c,
(select hzrc,hzyl from d01_1 where rq=v_rq) d,
(select count(jh) kjs from ly02 where rq=v_rq) e;

只有字符串语句才有占位符

[coolmurder]

我感觉是sqlplug里的rq变量没定义
var 一个就可以了