</p> 21 --中括号中的内容为([-d[:blank:]]),匹配失踪败,结不美观为空! I2 {5 ?4 B/ c& K' L
22 SELECT to_char(REGEXP_SUBSTR('SA01-2345 6789 0123 4567 8900',
. ?! [0 v! x2 Y5 o6 W6 f% P9 N: Z9 I 23 '(SA)?[-d[:blank:]]{22,50}',9 y, Y2 T5 h2 R+ r$ L6 }: x
24 1, 1,'i')) as Reg_Str FROM dual;
+ d# O" d9 H2 b9 H 25
) P/ e6 m9 u+ J0 u. Z G 26 --中括号内容如下,匹配失踪败,结不美观为空; y, m9 b4 m( _) U
27 SELECT to_char(REGEXP_SUBSTR('SA01-2345 6789 0123 4567 8900',+ a( ]7 Z v- L. `+ @
28 '(SA)?[-ds]{22,50}',
% I7 B0 V6 {8 M; _ 29 1, 1,'i')) as Reg_Str FROM dual;
. x4 }! O* d$ `- y! y B; n# D' S% e" Q/ ? 30( F, k0 v: ^9 A! q# b4 i2 H7 ^
31 --中括号内容如下,匹配失踪败,结不美观为空
z2 n3 n; l3 s5 O! f 32 SELECT to_char(REGEXP_SUBSTR('SA01-2345 6789 0123 4567 8900',& @2 i( X6 U9 R4 G4 l0 `
33 '(SA)?[-d ]{22,50}',
! s" L- L' ]: | 34 1, 1,'i')) as Reg_Str FROM dual;4 [2 k4 W; h$ Z' b$ |6 @
35( G# Z6 u; B' S0 G& d
36 --中括号中的内容为([-s]),匹配失踪败,结不美观为空. S9 b7 m6 j1 E; X
37 SELECT to_char(REGEXP_SUBSTR('SA01-2345 6789 0123 4567 8900',
1 Q& Y: v/ X# o1 n( ^ 38 'SAd{2}[-s]d{4}[-s]d{4}[-s]d{4}[-s]d{4}[-s]d{4}|SAd{22}',7 y3 g$ i b4 F. ~
39 1, 1,'i')) as Reg_Str FROM dual; |