SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Print content of codepage conversion (cntd)

531871Aug 4 2009 — edited Aug 5 2009

Hello

Given the sql:

select  tegn,  convert_back, 
        rn chr, upper(substr(dump(tegn,16),instr(dump(tegn,16),':')+2)) hex, 
        upper(substr(dump(convert(tegn, 'we8BS2000', 'WE8ISO8859P1'),10),instr(dump(convert(tegn, 'we8BS2000', 'WE8ISO8859P1'),10),':')+1)) chr_BS2000 ,
       upper(substr(dump(convert(tegn, 'we8BS2000', 'WE8ISO8859P1'),16),instr(dump(convert(tegn, 'we8BS2000', 'WE8ISO8859P1'),16),':')+1)) Hex_BS2000 ,
       case when convert_back = tegn then null else '... OBS ...' end obs
from (select level rn, chr(level) tegn, convert(convert(chr(level), 'we8BS2000', 'WE8ISO8859P1'),'WE8ISO8859P1','we8BS2000') convert_back
from dual connect by level <= 255);

It would be very nice to have a maxtrix print of a code page like this:

......    00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
------------------------------------------------------------------------------------
00-0F     00 01 02 03 37 2D 2E 2F 16 05 15 0B  0C 0D 0E 0F
10-1F     10 11 12 13 3C 3D 32 26 18 .......
20-2F
F0-FF
-------------------------------------------------------------------------------------
......    00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F

How do I chunk up the 256 lines resultset from the above SQL and make it into 16*16 lines the nicest way?

Best regards
Mette

This post has been answered by Frank Kulash on Aug 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2009

Added on Aug 4 2009

#pivot

2 comments

497 views