查询缺失旬度日期 with t as (
select '2001-10-1' d from dual union all
select '2001-10-2' d from dual union all
select '2001-10-3' d from dual union all
select '2002-11-1' d from dual union all
select '2002-11-3' d from dual union all
select '2006-1-2' d from dual union all
select '2007-2-1' d from dual union all
select '2008-11-1' d from dual)
select * from t
with t as (
select '2001-10-1' d from dual union all
select '2001-10-2' d from dual union all
select '2001-10-3' d from dual union all
select '2002-11-1' d from dual union all
select '2002-11-3' d from dual union all
select '2006-1-2' d from dual union all
select '2007-2-1' d from dual union all
select '2008-11-1' d from dual)
SELECT NY ------解决方案-------------------- '-' ------解决方案-------------------- RM
FROM (SELECT DISTINCT REGEXP_SUBSTR(D, '[[:alnum:]]+', 1, 1) ------解决方案-------------------- '-' ------解决方案--------------------
REGEXP_SUBSTR(D, '[[:alnum:]]+', 1, 2) NY
FROM T),
(SELECT ROWNUM RM FROM DUAL CONNECT BY ROWNUM &