Skip to Main Content

SQL & PL/SQL

query

407048Nov 19 2005 — edited Nov 19 2005
i have a table tab1 with one field fld1.
Values are

FLD1
------
101/102/103
105/102/109/108
110/111/112


I am looking for a query that can break each into a different line.(by removing commas)

Output should be

101
102
103
105
102
109
108
110
111
112
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2005
Added on Nov 19 2005
3 comments
2,439 views