;with tblA(DV,FA,GRD,OWN) As
(
      Select 'A','F1','H1','DES1' from DUAL Union All
      Select 'A','F1','H1','DES2' from DUAL Union All
      Select 'A','F1','H1','DES3' from DUAL Union All
      Select 'A','F1','K1','DES1' from DUAL Union All
      Select 'A','F1','K1','DES2' from DUAL Union All
      Select 'A','F1','K1','DES3' from DUAL Union All
      Select 'A','F1','S1','DES1' from DUAL Union All
      Select 'A','F1','S1','DES2' from DUAL Union All
      Select 'A','F1','S1','DES3' from DUAL Union All
      Select 'A','F2','H1','DES1' from DUAL Union All
      Select 'A','F2','H1','DES2' from DUAL Union All
      Select 'A','F2','H1','DES3' from DUAL Union All
      Select 'A','F2','K1','DES1' from DUAL Union All
      Select 'A','F2','K1','DES2' from DUAL Union All
      Select 'A','F2','K1','DES3' from DUAL Union All
      Select 'A','F2','S1','DES1' from DUAL Union All
      Select 'A','F2','S1','DES2' from DUAL Union All
      Select 'A','F2','S1','DES3' from DUAL 
)
,tbl1(DV,RN) As
(
      Select a.DV
            ,Row_Number() Over(Order By a.DV Asc) As rn
        From tblA a
    Group By a.DV
)
,tbl2(FA,RN) As
(
      Select a.FA
            ,Row_Number() Over(Order By a.FA Asc) As rn
        From tblA a
    Group By a.FA
)
,tbl3(GRD,RN) As
(
      Select a.GRD
            ,Row_Number() Over(Order By a.GRD Asc) As rn
        From tblA a
    Group By a.GRD
)
,tbl4(OWN,RN) As
(
      Select a.OWN
            ,Row_Number() Over(Order By a.OWN Asc) As rn
        From tblA a
    Group By a.OWN
)
      Select Max(a.DV)    As DV
            ,Max(a.FA)    As FA
            ,Max(a.GRD)   As GRD
            ,Max(a.OWN)   As OWN
        From (
                    Select a.DV   As DV
                          ,''     As FA
                          ,''     As GRD
                          ,''     As OWN
                          ,a.RN   As RN
                      From tbl1 a

                 Union All
                
                    Select ''     As DV
                          ,a.FA   As FA
                          ,''     As GRD
                          ,''     As OWN
                          ,a.RN   As RN
                      From tbl2 a

                 Union All
                
                    Select ''     As DV
                          ,''     As FA
                          ,a.GRD  As GRD
                          ,''     As OWN
                          ,a.RN   As RN
                      From tbl3 a

                 Union All
                
                    Select ''     As DV
                          ,''     As FA
                          ,''     As GRD
                          ,a.OWN  As OWN
                          ,a.RN   As RN
                      From tbl4 a
             ) a
     Group By a.RN
     Order By a.RN Asc
 

감사합니다.

이렇게는 생각을 못해봤습니다.

지금은 테스트할 상황이 못되어서,

내일 출근해서 확인해보고 활용해야겠네요.

다시한번 감사드립니다.

SELECT rn
     , MIN(dv ) dv
     , MIN(fa ) fa
     , MIN(grd) grd
     , MIN(own) own
  FROM (SELECT dv, fa, grd, own
             , ROW_NUMBER() OVER(
               PARTITION BY GROUPING_ID(dv, fa, grd, own)
               ORDER BY dv, fa, grd, own
               ) rn
          FROM tblA
         GROUP BY GROUPING SETS(dv, fa, grd, own)
        )
 GROUP BY rn
 ORDER BY rn
;