Sql query

[eddieawad]

I have an input string ('a','b','c')
Is there any way i can get the follg o/p using SQL (8i or 91 or 10g) (No PL/SQL)
'a'
'b'
'c'

I need the result to be displayed as 3 records
instead of 1 record

The no of columns in string may vary

What a coincidence! I blogged about the same problem today. Try this:

select substr (replace ('a,b,c', ','), rownum, 1) 
from all_objects 
where rownum <= length (replace ('a,b,c', ','));