title: How to split column value in Oracle sql
body: <p>How to split a column value which is not having space or any other delimiter. I searched the forums but I couldn't able to find the solution for my scenario.</p>
  
  <p><strong>Here is my scenario</strong></p>
  
  <pre>ID   Column_Value
  011  abcdefgh</pre>
  
  <p><strong>The result should be</strong></p>
  
  <pre>Column_Value1    Column_Value2
  abcd             efgh</pre>