title: how to return some default value in oracle cursor when nothing is found
body: <p>I have following statement in one of the oracle SP:</p>
  
  <pre><code>OPEN CUR_NUM FOR 
     SELECT RTRIM(LTRIM(num)) as num 
     FROM USER WHERE USER_ID = v_user_id;
  </code></pre>
  
  <p>When the above does not return anything the SP result just has no column name in it.  But I'd like the cursor to still have <code>num</code> column with some default value like <code>NOTHING</code> when no data is found.  </p>
  
  <p>Is this doable ?</p>