SELECT (REGEXP_SUBSTR('LW112190', '[A-Z0-9]', 1, ROWNUM)) test
  FROM DUAL
CONNECT BY ROWNUM <= LENGTH('LW112190')

Oracle 字符串拆分成一个一个字符_oracle