ORA-00907: 缺少右括号??TOAD,SQL*Plus里能执行

[cow8063]

C#，ASP。NET里面不能执行，如下SQL，奇怪。。。。。。。

select METERID,DEVICETYPE,max(case when TO_CHAR(DDATE,'yyyymmdd') =TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data1,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data2,(max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)-max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)) as METERNLLJ,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS1,max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS2 from TMPTODAY WHERE DEVICETYPE=16  AND METERID IN (SELECT METERNO FROM TDOOR_METER WHERE METERTYPE=16 ) group by  METERID, DEVICETYPE

[l13873666736]

TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd')
很是奇怪為什么脫庫子放屁
直接寫成'20100418'不就好了

[libinlink]

[Quote=引用 1 楼 cow8063 的回复:]
SQL code

select METERID,DEVICETYPE,
max(case when TO_CHAR(DDATE,'yyyymmdd') =TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data1,
max(case when TO_CHA……
[/Quote]
还是有缩进的好些。。。

[丰云]

这样写感觉没问题。。。

select METERID,DEVICETYPE,
 max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100417' then nvl(METERNLLJ,0) else 0 end) as data1,
 max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100418' then nvl(METERNLLJ,0) else 0 end) as data2,
(max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100418' then nvl(METERNLLJ,0) else 0 end)-
 max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100417' then nvl(METERNLLJ,0) else 0 end)) as METERNLLJ,
 max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100417' then DEVICESTATUS else 0 end) as DEVICESTATUS1,
 max(case when TO_CHAR(DDATE,'yyyymmdd') = '20100418' then DEVICESTATUS else 0 end) as DEVICESTATUS2 
 from TMPTODAY 
WHERE DEVICETYPE=16  
  AND METERID IN (SELECT METERNO FROM TDOOR_METER WHERE METERTYPE=16 ) 
group by  METERID, DEVICETYPE

[cow8063]

select METERID,DEVICETYPE,
max(case when TO_CHAR(DDATE,'yyyymmdd') =TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data1,
max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end) as data2,
(max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)-
max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then nvl(METERNLLJ,0) else 0 end)) as METERNLLJ,
max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-17','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS1,
max(case when TO_CHAR(DDATE,'yyyymmdd') = TO_CHAR(TO_DATE('2010-4-18','yyyy-mm-dd'),'yyyymmdd') then DEVICESTATUS else 0 end) as DEVICESTATUS2 
from TMPTODAY WHERE DEVICETYPE=16  AND METERID IN (SELECT METERNO FROM TDOOR_METER WHERE METERTYPE=16 ) 
group by  METERID, DEVICETYPE

[cow8063]

执行语句
public System.Data.DataTable GetTable(string sTableName)
{
OleDbConnection oleConn = new OleDbConnection(connStr);
OleDbCommand oleCommand = new OleDbCommand(sqlStr, oleConn);
OleDbDataAdapter oleDba = new OleDbDataAdapter(oleCommand);
DataSet dsTable = new DataSet();
oleDba.Fill(dsTable, sTableName);
oleConn.Close();
return dsTable.Tables[sTableName];
}

[huanmie_09]

sql没看出有什么问题.
C#不懂，帮顶!

[Leshami]

SQL 语句在Toad里可以执行吧？

[cow8063]

[Quote=引用 4 楼 robinson_0612 的回复:]
SQL 语句在Toad里可以执行吧？
[/Quote]、
可以呀， 程序里面不行
用的是9I

[ojuju10]

检查下C#代码