SQL>
SQL> WITH t(booking_class) AS
2 (SELECT 'YBM1UHWSE' FROM dual
3 UNION ALL
4 SELECT 'VFGV1MH' FROM dual)
5 SELECT regexp_substr(booking_class,'[[:alpha:]][^[:alpha:]]?',1,LEVEL) booking_class FROM t
6 CONNECT BY LEVEL<=regexp_count(booking_class,'[[:alpha:]][^[:alpha:]]?') AND booking_class= PRIOR booking_class AND PRIOR dbms_random.value IS NOT NULL;
BOOKING_CLASS
------------------
V
F
G
V1
M
H
Y
B
M1
U
H
W
S
E
14 rows selected --是要这样的效果吗