Skanda (10/8/2012)
Below code is working in 'Oracle'i need same output in sql.....
with digits as
( select n, chr(mod(n,36)+case when mod(n,36) < 10 then 48 else 55 end) d
from (Select rownum-1 as n from dual connect by level < 37)
)
select d0.n*36*36*36*36 + d1.n*36*36*36 + d2.n*36*36 + d3.n*36 + d4.n, d0.d||d1.d||d2.d||d3.d||d4.d
from digits d0,digits d1, digits d2, digits d3, digits d4
Plz
Chris covered how in his post, did you try it?
SELECT a.Chr+b.Chr+c.Chr+d.Chr
FROM (VALUES('0'),('1'),('2'),('3'),('4'),('5'),('6'),
('7'),('8'),('9'),('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')
)a(Chr)
CROSS JOIN (VALUES('0'),('1'),('2'),('3'),('4'),('5'),('6'),
('7'),('8'),('9'),('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')
)b(Chr)
CROSS JOIN (VALUES('0'),('1'),('2'),('3'),('4'),('5'),('6'),
('7'),('8'),('9'),('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')
)c(Chr)
CROSS JOIN (VALUES('0'),('1'),('2'),('3'),('4'),('5'),('6'),
('7'),('8'),('9'),('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')
)d(Chr)
ORDER BY a.Chr, b.Chr, c.Chr, d.Chr;