Query returning individual chars

Here is a query that puts each character of a given string in its own row:

select substr( 'eddie awad', rownum, 1) 
from all_objects 
where rownum <= length('eddie awad');

The table all_objects is used in the query as a row generator. Sweet.

Possibly related:

Tagged , | Post a Comment