oracle ´æ´¢¹ý³Ì×Ö·û´®³ö´í - Oracle / »ù´¡ºÍ¹ÜÀí

´æ´¢¹ý³ÌÖж¨ÒåµÄÒ»¸ö×Ö·û´®£¬ÔÚto_dateº¯Êý³ö´í¡£³ö´í´úÂëÈçÏ£ºÍû¸ßÈ˽â´ð£º
month_str:='select count(t.var_id) from wjc_inde_data_his t where t.var_id like ''%R'' and
  t.data_time>=to_date('||start_month||',''YYYY-MM-DD HH24:MI:SS'') and
  t.data_time<to_date('||stop_month||',''YYYY-MM-DD HH24:MI:SS'')';

´íÎóÌáʾ£º
ORA-00907: ȱʧÓÒÀ¨ºÅ
ORA-06512: ÔÚ "WJC.CALHISMIS", line 32
ORA-06512: ÔÚ line 1

---

start_month Íⲿ±äÁ¿?»¹ÊÇ....
Íⲿ±äÁ¿¼Ó:

---

Íⲿ±äÁ¿´«Èë.´¦Àíºó¸³Óèstart_monthºÍstop_month

---

SQL code:
--¸Ä³ÉÕâÑùÊÔÊÔ
month_str:='select count(t.var_id) from wjc_inde_data_his t where t.var_id like ''%R'' and
t.data_time>=to_date('''||start_month||''',''YYYY-MM-DD HH24:MI:SS'') and
t.data_time<to_date('''||stop_month||''',''YYYY-MM-DD HH24:MI:SS'')';

---

µ÷ÊÔÁËÏÂÄãµÄÓï¾ä
SQL code:
declare
month_str varchar2(200);
begin
month_str:='select count(t.var_id) from wjc_inde_data_his t where t.var_id like ''%R'' and
t.data_time>=to_date('||sysdate||',''YYYY-MM-DD HH24:MI:SS'') and
t.data_time<to_date('||sysdate||',''YYYY-MM-DD HH24:MI:SS'')';
dbms_output.put_line(month_str);
end;

µÃµ½½á¹û
select count(