split string into columns
I have the following data into table "admin_interval"
admin_interval table
--------------------
row1: "00:00:00 - 06:00:00, 22:00:00 - 23:59:59"
row2: "05:00:00 - 06:00:00"
and i want to split string into separate columns like from1, to1 from2, to2.
from1 to1 from2 to2
row1 00:00:00 06:00:00 22:00:00 23:59:59
row2 05:00:00 06:00:00
-----------------------------------------------
Could you please let me know how to do this in best way?
Subject
Written By
Posted
split string into columns
May 16, 2013 02:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.