title: Oracle 10g: truncate string
body: <p>I'm having a query that append a string value from multiple rows and insert the result in a new table.</p>
  
  <p>I would like to limit the String length that is inserted.</p>
  
  <p><strong>Question</strong></p>
  
  <p>What is the best way to achieve that :
  Should I use <code>SUBSTR</code> or <code>SUBSTRB</code> or is there a better way ?</p>