title: How to split varchar column in Oracle in three columns
body: <p>I have address field which can hold 120 characters and need to split it into three different columns 40 charcaters long each.</p>
  
  <p>Example: </p>
  
  <pre><code>Table name: Address 
  Column name: Street_Address
  Select Street_Address  * from Address
  </code></pre>
  
  <p>Output: 
  <code>123 Main St North Pole Factory 44, near the rear entrance cross the street and turn left and keep walking straight.</code></p>
  
  <p>I need to split this address into <code>address_1</code>
  <code>address_2</code>
  and <code>address_3</code>.</p>
  
  <p>All three addresses are <code>varchar(40)</code> datatype.</p>
  
  <p>So result should be something like this:</p>
  
  <pre><code>Address_1
  152 Main st North Pole Factory 44, near 
  
  Address_2
  the rear entrance cross the street and
  
  Address_3
  turn left and keep walking straight.
  </code></pre>
  
  <p>Please note that each address field can take up to 40 characters and has to be the whole word, it can't be truncated in half and left meaningless.</p>
  
  <p>I am using oracle 11i database.</p>