title: Split one row into multiple rows (fixed width)
body: <p>One row of incoming record has multiple sub-records concatenated. Each sub record is 9 characters long. I have 8 such sub-records in each row. So each row is (8x9=72 char). Is there a way i can split 1 record into 8 records here?</p>
  <h2>Input</h2>
  <pre><code>123456789123456789123456789123456789123456789123456789123456789123456789
  </code></pre>
  <h2>Output</h2>
  <pre><code>123456789 
  123456789
  123456789
  123456789
  123456789
  123456789
  123456789
  123456789
  </code></pre>
  <p>I know i can do this with 8 sub queries and union them .. is there a better way?</p>