• 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