orcale拆分字符算难题

[Yhs55]

查出的结果付图片；
这是想要的结果，请论坛的大神帮解决，谢谢
Y
B
M1
U
H
W
S
E
V
F
G
V1
M
H

[花开了叫我]

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 --是要这样的效果吗