title: Comparing fields in an ORACLE view
body: <p>I have an ORACLE table which includes the following fields:</p>
  
  <pre><code>FieldA1 NUMBER(10,0)
  FieldA2 VARCHAR2(40 BYTE)
  FieldB1 NUMBER(10,0)
  FieldB2 VARCHAR2(40 BYTE)
  </code></pre>
  
  <p>How do I write an ORACLE view that reads from the table and if the following condition is true:</p>
  
  <p>FieldA1 matches FieldB1 OR FieldA2 matches FieldB2</p>
  
  <p>outputs the character 'Y' as one of the columns and if the condition above isn't true outputs 'N' ?</p>