WITH Tab (pkey, dt, col1, col2, col3, col4, col5) AS ( 
    SELECT 1, sysdate, 0 , 0,  0,  0,  0  FROM dual UNION ALL
    SELECT 2, sysdate, 1 , 0,  0,  1,  0  FROM dual UNION ALL
    SELECT 3, sysdate, 0 , 1,  0,  0,  0  FROM dual UNION ALL
    SELECT 4, sysdate, 0 , 0,  0,  0,  0  FROM dual
)
SELECT
    tab.* 
FROM tab 
JOIN (
    SELECT pkey
    FROM tab UNPIVOT ( tvalue FOR tname IN ( col1, col2, col3, col4, col5 ) )
    WHERE tvalue = 0 -- 동일해야 하는 값
      AND tname in ( UPPER('col1'), UPPER('col2'), UPPER('col3'), UPPER('col4'), UPPER('col5') ) -- 동일해야 하는 칼럼들
    GROUP BY pkey 
    HAVING COUNT(pkey) = 5  -- 동일해야 하는 칼럼수
) BB ON tab.pkey = BB.pkey

-- tab 은 이미 사용되고 있는 명칭입니다. 다른 이름을 사용하세요.
WITH tab_1 AS
( 
SELECT sysdate dt, 0 col1, 0 col2, 0 col3 FROM dual
UNION ALL SELECT sysdate, 1, 0, 0 FROM dual
UNION ALL SELECT sysdate, 0, 1, 0 FROM dual
UNION ALL SELECT sysdate, 0, 0, 0 FROM dual
)
SELECT *
  FROM tab_1
 WHERE 0 = ALL(col1, col2, col3)
;