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.

Share this:

• Share

• Twitter
• Facebook
• LinkedIn
• Email
• StumbleUpon
• Google +1

Related articles:

• Paging through a query result
• Different ways to count
• NO_DATA_FOUND Gotcha

Filed in Oracle, Tips on 19 Jul 05 | Tags: sql, string

---

Reader's Comments

1. Nuno Souto | 20 Jul 2005 12:24 am

   Thanks, Eddie: that one is worth its weight in gold!

2. Eddie | 20 Jul 2005 11:04 pm

   I like these simple yet powerful SQL statements. I’ll keep on posting such queries here as soon as I discover them.