title: Oracle 12c Concatenate with brackets where nulls are involved
body: <p>We have a set of columns within a table we need to concatenate, and we need brackets around the third, fourth, fifth and sixth value, but also need nothing to appear if the column is null.</p>
  
  <pre><code>   SELECT "ID",
               NVL(PART || '.'|| SECTION ||'(' ||SUB1||')'|| '(' ||SUB2|| ')'     || '('||SUB3||')' || '('||SUB4||')', '')  as concatenated
                FROM table1;
  </code></pre>
  
  <p>Places the values exactly right as long as there are values.  When any one or more columns return null, we are getting an empty set of brackets for each null value.</p>
  
  <p>Such as:  113.203()()()() when there are four null values
    in this case we would need: 113.203</p>
  
  <p>Or 113.450(h)(2)(iv)() when there is one null value.
   here the desired results 
  would be 113.450(h)(2)(iv)</p>
  
  <p>How can I change the script to leave out all the empty brackets when a null value is returned?</p>
  
  <p>Thank you.</p>