oracle处理特殊字符
DECLARE
V01 VARCHAR2(5);
BEGIN
FOR I IN 1..100 LOOP
SELECT CHR(I) INTO V01 FROM DUAL;
DBMS_OUTPUT.PUT_LINE('chr'||i||' is '||V01);
END LOOP;
END;
chr1 is
chr2 is
chr3 is
chr4 is
chr5 is
chr6 is
chr7 is
chr8 is
chr9 is
chr10 is
chr11 is
chr12 is
chr13 is
chr14 is
chr15 is
chr16 is
chr17 is
chr18 is
chr19 is
chr20 is
chr21 is
chr22 is
chr23 is
chr24 is
chr25 is
chr26 is
chr27 is
chr28 is
chr29 is
chr30 is
chr31 is
chr32 is
chr33 is !
chr34 is "
chr35 is #
chr36 is $
chr37 is %
chr38 is &
chr39 is '
chr40 is (
chr41 is )
chr42 is *
chr43 is +
chr44 is ,
chr45 is -
chr46 is .
chr47 is /
chr48 is 0
chr49 is 1
chr50 is 2
chr51 is 3
chr52 is 4
chr53 is 5
chr54 is 6
chr55 is 7
chr56 is 8
chr57 is 9
chr58 is :
chr59 is ;
chr60 is <
chr61 is =
chr62 is >
chr63 is ?
chr64 is @
chr65 is A
chr66 is B
chr67 is C
chr68 is D
chr69 is E
chr70 is F
chr71 is G
chr72 is H
chr73 is I
chr74 is J
chr75 is K
chr76 is L
chr77 is M
chr78 is N
chr79 is O
chr80 is P
chr81 is Q
chr82 is R
chr83 is S
chr84 is T
chr85 is U
chr86 is V
chr87 is W
chr88 is X
chr89 is Y
chr90 is Z
chr91 is [
chr92 is \
chr93 is ]
chr94 is ^
chr95 is _
chr96 is `
chr97 is a
chr98 is b
chr99 is c
chr100 is d