SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error while execute the query/ORA-01476: divisor is equal to zero

SITISep 4 2019 — edited Sep 5 2019

Hi All,

Thanks in Advance,

While, i have executed the below query in SQL Developer window , i am getting the attached error

select table_name,avg_row_len,round(((blocks*16/1024)),2)||'MB' "TOTAL_SIZE",round((num_rows*avg_row_len/1024/1024),2)||'Mb' "ACTUAL_SIZE",

round(((blocks*16/1024)-(num_rows*avg_row_len/1024/1024)),2) ||'MB' "FRAGMENTED_SPACE",

(round(((blocks*16/1024)-(num_rows*avg_row_len/1024/1024)),2)/round(((blocks*16/1024)),2))*100 "percentage"

from dba_tables

ORA-01476: divisor is equal to zero

01476. 00000 - "divisor is equal to zero"

*Cause:

*Action:

please advice, where to change. Thanks!!!

Regards,

Added on Sep 4 2019

11 comments

2,725 views