split function
685758Jul 2 2009 — edited Jul 2 2009Hi ,
select split('123,45,6,7',1,',') from dual
---------------------------------------------------------------------
result 123
---------------------------------------------------------------------
In above query only 1st value(123) will be in result .
Is there any way to fetch all values from above query .
I wana result like below in one query..help me.
result
123
45
6
7