[오라클] 특수문자 코드

 select * from 
(
    select '1' no ,chr(1) as v_chr from dual
union select '2' no ,chr(2) as v_chr from dual
union select '3' no , chr(3) as v_chr from dual
union select '4' no , chr(4) as v_chr from dual
union select  '5' no ,chr(5) as v_chr from dual
union select  '6' no ,chr(6) as v_chr from dual
union select  '7' no ,chr(7) as v_chr from dual
union select  '8' no ,chr(8) as v_chr from dual
union select  '9' no ,chr(9) as v_chr from dual
union select  '10' no ,chr(10) as v_chr from dual
union select  '11' no ,chr(11) as v_chr from dual
union select  '12' no ,chr(12) as v_chr from dual
union select  '13' no ,chr(13) as v_chr from dual
union select  '14' no ,chr(14) as v_chr from dual
union select  '15' no ,chr(15) as v_chr from dual
union select  '16' no ,chr(16) as v_chr from dual
union select  '17' no ,chr(17) as v_chr from dual
union select  '18' no ,chr(18) as v_chr from dual
union select  '19' no ,chr(19) as v_chr from dual
union select  '20' no ,chr(20) as v_chr from dual
union select  '21' no ,chr(21) as v_chr from dual
union select  '22' no ,chr(22) as v_chr from dual
union select  '23' no ,chr(23) as v_chr from dual
union select  '24' no ,chr(24) as v_chr from dual
union select  '25' no ,chr(25) as v_chr from dual
union select  '26' no ,chr(26) as v_chr from dual
union select  '27' no ,chr(27) as v_chr from dual
union select  '28' no ,chr(28) as v_chr from dual
union select  '29' no ,chr(29) as v_chr from dual
union select  '30' no ,chr(30) as v_chr from dual
union select  '31' no ,chr(31) as v_chr from dual
union select  '32' no ,chr(32) as v_chr from dual
union select  '33' no ,chr(33) as v_chr from dual
union select  '34' no ,chr(34) as v_chr from dual
union select  '35' no ,chr(35) as v_chr from dual
union select  '36' no ,chr(36) as v_chr from dual
union select  '37' no ,chr(37) as v_chr from dual
union select  '38' no ,chr(38) as v_chr from dual
union select  '39' no ,chr(39) as v_chr from dual
union select  '40' no ,chr(40) as v_chr from dual
union select  '41' no ,chr(41) as v_chr from dual
union select  '42' no ,chr(42) as v_chr from dual
union select  '43' no ,chr(43) as v_chr from dual
union select  '44' no ,chr(44) as v_chr from dual
union select  '45' no ,chr(45) as v_chr from dual
union select  '46' no ,chr(46) as v_chr from dual
union select  '47' no ,chr(47) as v_chr from dual
union select  '48' no ,chr(48) as v_chr from dual
union select  '49' no ,chr(49) as v_chr from dual
union select  '50' no ,chr(50) as v_chr from dual
union select  '51' no ,chr(51) as v_chr from dual
union select  '52' no ,chr(52) as v_chr from dual
union select  '53' no ,chr(53) as v_chr from dual
union select  '54' no ,chr(54) as v_chr from dual
union select  '55' no ,chr(55) as v_chr from dual
union select  '56' no ,chr(56) as v_chr from dual
union select  '57' no ,chr(57) as v_chr from dual
union select  '58' no ,chr(58) as v_chr from dual
union select  '59' no ,chr(59) as v_chr from dual
union select  '60' no ,chr(60) as v_chr from dual
union select  '61' no ,chr(61) as v_chr from dual
union select  '62' no ,chr(62) as v_chr from dual
union select  '63' no ,chr(63) as v_chr from dual
union select  '64' no ,chr(64) as v_chr from dual
union select  '65' no ,chr(65) as v_chr from dual
union select  '66' no ,chr(66) as v_chr from dual
union select  '67' no ,chr(67) as v_chr from dual
union select  '68' no ,chr(68) as v_chr from dual
union select  '69' no ,chr(69) as v_chr from dual
union select  '70' no ,chr(70) as v_chr from dual
union select  '71' no ,chr(71) as v_chr from dual
union select  '72' no ,chr(72) as v_chr from dual
union select  '73' no ,chr(73) as v_chr from dual
union select  '74' no ,chr(74) as v_chr from dual
union select  '75' no ,chr(75) as v_chr from dual
union select  '76' no ,chr(76) as v_chr from dual
union select  '77' no ,chr(77) as v_chr from dual
union select  '78' no ,chr(78) as v_chr from dual
union select  '79' no ,chr(79) as v_chr from dual
union select  '80' no ,chr(80) as v_chr from dual
union select  '81' no ,chr(81) as v_chr from dual
union select  '82' no ,chr(82) as v_chr from dual
union select  '83' no ,chr(83) as v_chr from dual
union select  '84' no ,chr(84) as v_chr from dual
union select  '85' no ,chr(85) as v_chr from dual
union select  '86' no ,chr(86) as v_chr from dual
union select  '87' no ,chr(87) as v_chr from dual
union select  '88' no ,chr(88) as v_chr from dual
union select  '89' no ,chr(89) as v_chr from dual
union select  '90' no ,chr(90) as v_chr from dual
union select  '91' no ,chr(91) as v_chr from dual
union select  '92' no ,chr(92) as v_chr from dual
union select  '93' no ,chr(93) as v_chr from dual
union select  '94' no ,chr(94) as v_chr from dual
union select  '95' no ,chr(95) as v_chr from dual
union select  '96' no ,chr(96) as v_chr from dual
union select  '97' no ,chr(97) as v_chr from dual
union select  '98' no ,chr(98) as v_chr from dual
union select  '99' no ,chr(99) as v_chr from dual
union select  '100' no ,chr(100) as v_chr from dual
) order by TO_NUMBER(no) asc



오라클 자동적으로 차단하는 특수문자를 사용하기 위한 방법.