将文本内容以key value的形式输出
name fdafa
age 28
provice guangdong
tel 13458545454
age 28
provice guangdong
tel 13458545454
with tablea as
(select 'name:fdafa;age:28;provice:guangdong;tel:13458545454' name
from dual)
select substr(cname, 1, instr(cname, ':') - 1) key,
substr(cname, instr(cname, ':') + 1) value
from (select regexp_substr(a.name, '[^;]+', 1, level) cname
from tablea a
connect by level <
length(a.name) - length(replace(a.name, ':', '')) + 1);