请问oracle的sql中有没有case函数,如何用呀?另外我在sql server中写的语句(见下面)SELECT SID,
QuDuanNo
FROM qu_info
Union
SELECT SID = 0, QuDuanNo = ''
这句话怎么在oracle的sql中用呢?
QuDuanNo
FROM qu_info
Union
SELECT SID = 0, QuDuanNo = ''
这句话怎么在oracle的sql中用呢?
楼主的意思是不是SELECT SID,
QuDuanNo
FROM qu_info
Union
SELECT 0 AS SID,NULL AS QuDuanNo FROM DUAL
ORCALE中可以用CASE 语句
ORACLE中CASE ... WHEN... THEN... ELSE... END
或者CASE WHEN... THEN... ELSE... END