시간이 여유 있으면 더 쉽게 할텐데...

일단 필요한 정보만 드립니다.

WITH tab AS
(
 SELECT '111'  zip FROM dual UNION ALL
 SELECT '222'  zip FROM dual UNION ALL
 SELECT '333'  zip FROM dual UNION ALL
 SELECT 'zz5'  zip FROM dual UNION ALL
 SELECT 'yA5'  zip FROM dual UNION ALL
 SELECT '734'  zip FROM dual UNION ALL
 SELECT 'zZ1$1234'  zip FROM dual UNION ALL
 SELECT 'junsunH1!' zip FROM dual
 )
 SELECT zip
  FROM tab
 WHERE REGEXP_LIKE(zip, '[[:digit:]]')  -- 숫자포함
 AND REGEXP_LIKE(zip, '[[:lower:]]')    -- 소문자포함
 AND REGEXP_LIKE(zip, '[[:upper:]]')    -- 대문자포함
 AND REGEXP_LIKE(zip, '[[:punct:]]')    -- 특수문자포함
 AND length(zip) > 7  -- 8자 이상