Now we can use a simple SQL statement to convert the same.
|SELECT SUBSTR('A,B,C,D,E,F', |
LEVEL)-1,1) FROM DUAL
CONNECT BY LEVEL <= LENGTH(
To elaborate the technique, we have used the following logic:
1. Used CONNECT BY statement to find out how many rows are necessary
2. INSTR to find out the place of each row
3. SUBSTR to cut the string between the comma
Well what was the assumptions before using this query. The string between comma are having length of one. Any number of strings can be given in this fashion.