Print current Oracle character set

Short PL/SQL block to print the characters in range [033..256]

SET serveroutput ON

DECLARE
 i NUMBER;
 j NUMBER;
 k NUMBER;
BEGIN
FOR i IN 2..15 LOOP
 FOR j IN 1..16 LOOP
 k:=i*16+j;
 dbms_output.put((TO_CHAR(k,'000')) || ':' || CHR(k) || ' ' );
 IF k MOD 8 = 0 THEN
   dbms_output.put_line('');
  END IF;
 END LOOP;
END LOOP;
END;
Bookmark and Share

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>