SQL> -- HOW TO GENERATE ALPHABETS WITH ORACLE SQL QUERIES
SQL>
SQL>
SQL> SELECT CHR(X.RNO +64) "ALPHA" FROM (
2 select level rno
3 from dual
4 connect by level <= 26 ) X ;
26 rows selected
SQL>
SQL>
SQL>
SQL> SELECT CHR(X.RNO +64) "ALPHA" FROM (
2 select level rno
3 from dual
4 connect by level <= 26 ) X ;
ALPHA
-----
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
26 rows selected
SQL>
1 comment:
Thanks.
Post a Comment