title: nvl with query inside
body: <p>Its possible to do something like this:</p>
  
  <pre><code>and zmt.mediatypeid in nvl(:P21_MEDIA, select mediatypeid from zbx.media_type)
  </code></pre>
  
  <p>:P21_MEDIA is a variable</p>