Re: Computing percentage change between tables
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Mon, 20 Jul 2009 11:14:09 +0200
Message-ID: <h41ch1$31l$1_at_news.eternal-september.org>
novice82 escribió:
> another question, that I have is, how does sql handle the computation,
> if a value in a particular field is divided by 0 ?
Date: Mon, 20 Jul 2009 11:14:09 +0200
Message-ID: <h41ch1$31l$1_at_news.eternal-september.org>
novice82 escribió:
> another question, that I have is, how does sql handle the computation,
> if a value in a particular field is divided by 0 ?
It raises a ORA-01476 error ("divisor is equal to zero"). You can test it yourself:
SELECT 1/0
FROM DUAL
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://borrame.com -- Mi web de humor satinado: http://www.demogracia.com --Received on Mon Jul 20 2009 - 04:14:09 CDT