title: Return a value if no rows selected are found Oracle
body: <p>Here's my simple query. If I query a record that doesn't exist then I will get nothing returned.</p>
  
  <pre><code>SELECT
  CASE WHEN table1.column1= @column1  THEN 'XX' 
  ELSE 'YY' END from table1 where table1.column2=@column2
  </code></pre>
  
  <p>It returns no rows selected.</p>
  
  <p>I tried <code>ISNULL()</code> .But not rectified </p>
  
  <p>I need to return 'YY'</p>
  
  <p>Could anyone helpme out..!!
  Thanks in Advance!!</p>