01476

===

0으로 나눌 수 없음

1. 해당 컬럼에 밑의 수식을 작성 sql ROUND(NVL(column_name1/DECODE(column_name2, 0, NULL, column_name2), 0))

2. 예시 sql 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 ;