我在Oracle数据库里有一个字符串,我的字符串是:'bbb;aaa;qqq;ccc‘select distinct trim(regexp_substr('bbb;aaa;qqq;ccc','[^;]+', 1,level) ) as q connect by regexp_substr('bbb;aaa;qqq;ccc', '[^;]+',1, level) is not
我有以下查询,我试图将其拆分为"Name:“。输出将按如下方式插入到表中。但这不像预期的那样有效。procedure p_ins (par_string in varchar2) is insert into TBL_TEST (Name) from dual
connect by level <= rege
\n这将按预期插入所有记录。但是,我想将每一条记录逐一插入到CLOB列中。每一项记录的末尾都有断线现象。如何通过将附加功能合并到处理程序或过程中来拆分它们?create_kayit (p_kayit IN CLOB) AS INSERT INTO UEMTEST (KAYIT) REGEXP_SUBSTR(p_kayit, '.+', 1, level, 'm') KAYIT
FROM DUAL conn