title: ERROR at line 191: ORA-01489: result of string concatenation is too long
body: <pre><code>Select TO_CLOB(a)|| TO_CLOB(b)|| TO_CLOB(c) || TO_CLOB(d) 
    from table1
  </code></pre>
  
  <p>Above query is not spooling the data properly into text file.</p>
  
  <p>whereas,</p>
  
  <pre><code>Select a||b||c||d 
    from table1.
  </code></pre>
  
  <p>is ending to </p>
  
  <blockquote>
    <p>ERROR at line 191: ORA-01489: result of string concatenation is too long.</p>
  </blockquote>
  
  <p>Please help !!!</p>