how to separate mobileno and landlineno in oracle(input is in single field) [message #409192] |
Sat, 20 June 2009 01:51  |
arun.dwh
Messages: 1 Registered: June 2009
|
Junior Member |
|
|
I have text file like this
(INPUT)
phone_no
9942242132*04423659874*04478942516*9942242358*9987 456224
9944542132*942362358*04478918516*04423869874*99874 58224*04456987214
I need OUT PUT like this( out put is in oracle)
mobileno,landlineno
9942242132,04423659874
9942242358,04478942516
9987456224,04423869874
9944542132,04478918516
9987458224,04456987214
942362358
|
|
|
|