17,082
社区成员
发帖
与我相关
我的任务
分享
with tmp as
(
select 'H0201' st_code from dual union all
select 'H020115' from dual union all
select 'H0101' from dual union all
select 'H010102' from dual union all
select 'H020103' from dual union all
select 'H03' from dual
)
select distinct t1.st_code
from tmp t1
where not exists(select null
from tmp t2
where instr(t1.st_code, t2.st_code) >0
and t2.st_code <> t1.st_code
);
WITH TMP AS
(SELECT 'H0201' ST_CODE
FROM DUAL
UNION ALL
SELECT 'H020115'
FROM DUAL
UNION ALL
SELECT 'H0101'
FROM DUAL
UNION ALL
SELECT 'H010102'
FROM DUAL
UNION ALL
SELECT 'H03'
FROM DUAL
UNION ALL
SELECT '0H03'
FROM DUAL)
SELECT *
FROM TMP T
WHERE NOT EXISTS (SELECT 1
FROM TMP T1
WHERE REGEXP_LIKE(T.ST_CODE, '^'||T1.ST_CODE)
AND T1.ST_CODE <> T.ST_CODE)
WITH TMP AS
(SELECT 'H0201' ST_CODE
FROM DUAL
UNION ALL
SELECT 'H020115'
FROM DUAL
UNION ALL
SELECT 'H0101'
FROM DUAL
UNION ALL
SELECT 'H010102'
FROM DUAL
UNION ALL
SELECT 'H03'
FROM DUAL)
SELECT *
FROM TMP T
WHERE NOT EXISTS (SELECT 1
FROM TMP T1
WHERE REGEXP_LIKE(T.ST_CODE, T1.ST_CODE)
AND T1.ST_CODE <> T.ST_CODE)