使用 LEVEL 可以遍历,如下例子: SELECT SUBSTR(COLUMN_NAME,LEVEL,1) AS COL FROM TAB_NAME CONNECT BY LEVEL <= LENGTH(COLUMN_NAME);