oracle如果,如果选择（ORACLE）

嗨声明我只是选择和伟大工程：如果选择(ORACLE)

select 'CARAT Issue Open' issue_comment, i.issue_id, i.issue_status, i.issue_title, i.ISSUE_summary ,i.issue_description, i.severity,

gcrs.Area_name, gcrs.sector_name,

substr(gcrs.stream_name,1,case when instr(gcrs.stream_name,' (')=0 then 100 else instr(gcrs.stream_name,' (')-1 end) ISSUE_DIVISION,

case when gcrs.STREAM_NAME like 'NON-GT%' THEN 'NON-GT' ELSE gcrs.STREAM_NAME END as ISSUE_DIVISION_2

from table(f_carat_issues_as_of('31/MAR/2013')) i

inner join v_gcrs_with_stream gcrs on i.segment_id = gcrs.segment_id

where UPPER(ISSUE_STATUS) like '%OPEN%'

现在我想打电话给两列： ISSUE_DIVISION和ISSUE_DIVISION_2

，如果他们在新列等于应值1如果不相等应该是0，

我该怎么办？

我全码：

select 'CARAT Issue Open' issue_comment, i.issue_id, i.issue_status, i.issue_title, i.ISSUE_summary ,i.issue_description, i.severity,

gcrs.Area_name, gcrs.sector_name,

substr(gcrs.stream_name,1,case when instr(gcrs.stream_name,' (')=0 then 100 else instr(gcrs.stream_name,' (')-1 end) ISSUE_DIVISION,

case when gcrs.STREAM_NAME like 'NON-GT%' THEN 'NON-GT' ELSE gcrs.STREAM_NAME END as ISSUE_DIVISION_2

from table(f_carat_issues_as_of('31/MAR/2013')) i

inner join v_gcrs_with_stream gcrs on i.segment_id = gcrs.segment_id

where UPPER(ISSUE_STATUS) like '%OPEN%' and

CASE WHEN ISSUE_DIVISION = ISSUE_DIVISION_2 THEN

CASE WHEN ISSUE_DIVISION is null then "Null Value found"

Else 1 End

ELSE 0 END As Issue_Division_Result

，但我得到的行错误： ELSE 0 END作为Issue_Division_Result

ORA-00920：无效的关系运算符:(

2013-03-25

4est

+0

这将无法正确处理GCRS.STREAM_NAME的NULL值，因为在这种情况下INSTR()返回NULL。 –

2013-03-25 12:29:03