ORA-00933: SQL 命令未正确结束
SELECT MAX(NVL(rawvalue,0)),mettime,valuetype FROM cmetvalue3 WHERE metid = 1001000007 AND meastype = 1 AND mettime >2003-6-6 08:00:00 AND mettime <= 2003-7-4 00:00:00 GROUP BY mettime,valuetype
SELECT MAX(NVL(rawvalue,0)),mettime,valuetype FROM cmetvalue3 WHERE metid = 1001000007 AND meastype = 1 AND mettime >2003-6-6 08:00:00 AND mettime <= 2003-7-4 00:00:00 GROUP BY mettime,valuetype
改为mettime >to_date('2003-06-06 08:00:00','yyyy-mm-dd h24:mi:ss')
mettime >2003-6-6 08:00:00
改为(加引号)
mettime >'2003-6-6 08:00:00'再试验一下吧
我使用过SQL语句动态生成过数据存储,只要SQL语句正确基本没有问题.
有一个PB的BUG,就是把每一行SQL语句的前面或者之后加些TABLE,空格之类的分割符号,这个在PB60/65常常遇到,在创建数据窗口的时候就有这个问题,在数据存储中同样有。