with t as (
select '20070425' no, 2011 yr from dual union all
select '20070425', 2010 from dual union all
select '20070425', 2009 from dual union all
select '20070425', 2007 from dual union all
select '20060425', 2011 from dual union all
select '20060425', 2010 from dual union all
select '20060425', 2008 from dual union all
select '20060425', 2006 from dual
),    p as (
select 2005 + level yr
  from dual
connect by level <= 20
),    c as (
select '20070425' no from dual union all
select '20060425' from dual
),    n as (
select no
     , min(yr) min_yr
     , max(yr) max_yr
  from t
 group by no
)
select a.no, a.yr
  from ( select no, yr
           from p, c
       )  a
      , t b
      , n c
 where a.no  = b.no (+)
   and a.yr  = b.yr (+)
   and a.no  = c.no
   and a.yr >= c.min_yr
   and a.yr <= c.max_yr
   and b.yr is null
 order by 1, 2 desc

가로로 펼치지는 못했습니다.

답변 감사드립니다.

그런데.. 이건 예시라서요..

수백 개의 회원사를 조회하는건데, 알려 주신 형태로 하는 건 불가능할 것 같네요. ^_^;;