title: Create Materialized View using SELECT and adding new values where NULL
body: <p>I am attempting to create a materialized view in SQL Developer using a SELECT statement referencing an existing table but would like to add values to the materialized view if a column value in the existing table is null, otherwise just leave the column value as per the table.</p>
  
  <p>For example:</p>
  
  <pre><code>Create materialized view MVIEW_NAME as (
   SELECT A.* from tableOne A
     CASE WHEN A.colName IS NULL THEN A.colName=NewValue
     END CASE
  )
  </code></pre>
  
  <p>Clearly the syntax for this is incorrect but not sure how to do it or if there is an IF STATEMENT or something that could do it? Thanks for any help.</p>