[Oracle] 오라클 비율함수 RATIO_TO_REPORT WITH T_BASE AS ( SELECT /*GUBUN은 1,2,3,4의 구분코드로 구분*/ GUBUN, COUNT(*) CNT FROM TBL1 GROUP BY GUBUN ) SELECT GUBUN, ROUND(RATIO_TO_REPORT(CNT) OVER()*100,2)||'%' PCNT FROM T_BASE ORDER BY 1; 조회결과 예시 GUBUN / PCNT 1 / 20% 2 / 20% 3 / 20% 4 / 40%