Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loop through letters of the alphabet...

724687Feb 17 2011 — edited Feb 17 2011
Maybe a simple question, but I just don't figure it out:

How can I write a loop through all the letters of the alphabet, without the need of an array with all the letters?

Somthing like
l_char_loop CHAR(1) := 'A';

begin
  loop

   /* Do the stuff for the letter 'A'*/

    l_char_loop = l_char_loop + 1 (or something like that)
    exit when l_char_loop = 'Z'
end;
This post has been answered by Karthick2003 on Feb 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2011
Added on Feb 17 2011
4 comments
7,107 views