title: If statement in select (ORACLE)
body: <p>Hi I have simply select and works great:</p>
  
  <pre><code>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%'
  </code></pre>
  
  <p>Now I want to call two columns:
  ISSUE_DIVISION and ISSUE_DIVISION_2</p>
  
  <p>if they are equal in new columns should be value 1 if are not equal should be 0,</p>
  
  <p>how can I do it ? </p>
  
  <hr>
  
  <p>my full code:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>but I get error on line:
      ELSE 0 END As Issue_Division_Result</p>
  
  <p>ORA-00920: invalid relational operator :(</p>