title: Within a Query can you have a result changed to something based on a returned value
body: <p>Oracle SQL Developer Version 18.2.0.183, Build 183.1748</p>
  
  <p>This request for help comes from a lack of knowledge on the subject. I have a query I am working on and one of the fields in the Query will always return a Value of either "S" or "C". Anytime a "S" is returned I need that field to instead of outputting a "S" to instead output "Residential" and anytime a "C" is returned to instead output "Commercial".</p>
  
  <p>Here is a Sample of the query:</p>
  
  <pre><code>    SELECT
      DBSTAGE.OAWOM.WORKORDERNUMBER "Work Order Number", 
      DBSTAGE.OAWOM.BILLTYPECODE "Bill Type Code", 
      DBSTAGE.OAWOD.SERVICECODE "Line Description"
      FROM
      DBSTAGE.OAWOM, 
      DBSTAGE.AOWOD
      WHERE
      DBSTAGE.OAWOM.WORKORDERNUMBER = DBSTAGE.OAWOD.WORKORDERNUMBER 
      AND DBSTAGE.OAWOM.SITEID = DBSTAGE.OAWOD.SITEID
  </code></pre>
  
  <p>This query outputs the following:
  <a href="https://i.stack.imgur.com/tXOXG.png" rel="nofollow noreferrer">"ACTUAL OUTPUT"</a></p>
  
  <p>And I am wanting it to instead output this:
  <a href="https://i.stack.imgur.com/z89NK.png" rel="nofollow noreferrer">"DESIRED OUTPUT"</a></p>