如何实现将'one,two,three,four,five'
按下面的形式打印出来
one
two
there
four
five
方法一:
语句实现:
select regexp_substr('one,two,three,four,five','[^,]+',1,level,'i') from dual CONNECT BY LEVEL <= 5
方法二:函数实现
create or replace function t_print(v in varchar2) return varchar2 is
t varchar2(30):=";
vv varchar2(30):='';
begin
for i in (select 'one,two,three,four,five' from dual)loop
;