CHAR_STAIRS

Hi Expert,

I have letter from A..Z   how can be solve it using SQL/PLSQL

Looking for O/P like below::
-----------------------------------
ABCD
EFGH
IJKL
MNOP
QRST
UVWX
YZ

Please  suggest on this.

Thanks in Advance!!
MIHIR KAR#Oracle_DB #UNIX beginnerAsked:
Who is Participating?
 
Geert GOracle dbaCommented:
O/P ... output ... djees, guess it 's monday

select rtrim(chr(64+(level-1)*4+1)||chr(64+(level-1)*4+2)||chr(64+(level-1)*4+3)||chr(64+(level-1)*4+4), '[\') op from dual
connect by level < 8;

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.