substr和length函数 合用

--- 方式1

select substr('linshujiang', rownum, 1) username
from all_objects
where rownum <= length('linshujiang');

 

---方式2

select substr('linshujiang', rownum, 1)
from dual
connect by rownum <= length('linshujiang')

 

综上效果是一样的