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
 

创建时间:2022-04-02 14:26
浏览量:0