实例01:
CREATE TABLE T3 (
LX VARCHAR2(10),
DM VARCHAR2(20),
QX VARCHAR2(3000)
);
insert into T3 values('CK09','mp702','about|accept|cancel|controlg|controlp');
select LX, DM, regexp_substr(QX, '[^|]+',1,level) new_item
from t3 connect by level <= regexp_count(qx,'|') + 1
and prior rowid = rowid
and prior dbms_random.value is not null
and regexp_substr(QX, '[^|]+',1,level) is not null
实例02:
create table a (
cid number,
num numbe