title: how to set NVL on SQL with TO_CHAR(MAX)
body: <p>I trying to set a <code>nvl()</code> with the value OPEN on ->   </p>
  
  <pre><code>        select to_char(max(CLOSE_DATE),'dd.mm.yyyy hh24:mi:ss') 
  </code></pre>
  
  <p>If it is closed is getting the date ('dd.mm.yyyy hh24:mi:ss') otherwise it should display OPEN</p>
  
  <p>Any ideas, where I can put correctly the <code>NVL()</code>?</p>
  
  <p>Solution:</p>
  
  <pre><code>        select nvl (to_char(max(CLOSE_DATE),'dd.mm.yyyy hh24:mi:ss'), 'OPEN')
  </code></pre>
  
  <hr>