01476

===

0으로 나눌 수 없음

1. 해당 컬럼에 밑의 수식을 작성

   ROUND(NVL(column_name1/DECODE(column_name2, 0, NULL, column_name2), 0))
   

2. 예시

   SELECT * FROM ( 
     SELECT
       SQL_ID, MODULE, CPU_TIME, ELAPSED_TIME,
       ROUND(NVL(ELAPSED_TIME/DECODE(EXECUTIONS, 0, NULL, EXECUTIONS), 0)) AS avg_elapsed,
       ROUND(NVL(CPU_TIME/DECODE(EXECUTIONS, 0, NULL, EXECUTIONS), 0)) AS avg_cpu,
       SQL_TEXT 
     FROM V$SQL
     ORDER BY avg_elapsed DESC
   )
   WHERE ROWNUM <= 100
   ;