ORACLE sql 列转行

select TRIM(SUBSTR('ABCD',LEVEL,1) )AS X
 from dual
 CONNECT BY LEVEL <=length('ABCD') ;