title: SQL Select statement - default field value when field doesn't exist
body: <p>I'm wondering whether there is a way to display some default value for select statement where queries field doesn't exist.</p>
  
  <p>For instance,</p>
  
  <pre><code>SELECT t.name, t.type, t.price, t.brand FROM some_table t;
  </code></pre>
  
  <p>If the 'brand' field doesn't exist in the some_table I would like this statement to display 'brand' as 'not available'.</p>
  
  <p>Eventually I want to create a view from that select statement.
  I'm just curious whether there is a way to do that in PL/SQL.</p>
  
  <p>EDIT:
  To avoid confusion, I want the statement to compile and work when the 'brand' column doesn't exist in the table.</p>