--sequence AAAAA to ZZZZZ....... wow.
select CHR(65+MOD((rownum-1)/(26*26*26*26), 26))
||CHR(65+MOD((rownum-1)/(26*26*26), 26))
||CHR(65+MOD((rownum-1)/(26*26), 26))
||CHR(65+MOD((rownum-1)/26, 26))
||CHR(65+MOD((rownum-1), 26)) as AA_ZZ_sequence
from dual
connect by level <= 26*26*26*26*26;
This is along the lines of a trick sql statement and demonstrates what can be achieved when you use the connect by terminology.
No comments:
Post a Comment