OraFAQ Forum: SQL & PL/SQL » second case issue

Home » SQL & PL/SQL » SQL & PL/SQL » second case issue

Wed, 27 September 2006 07:02

steffeli
Messages: 112
Registered: July 2006

Senior Member

Hello

how can I prevent an error division by 0?

I calculate a param in my select statement, where a and b stands for calculation (several rows)

select  a/b as param

I could write

select  case when b <> 0
             then a/b
             else null
        end as param

but the issue is, that I have to write b (which is several rows) twice. Is there a better solution to prevent division by 0?

Thanks
Stefan

Wed, 27 September 2006 20:03

rleishman
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia

Senior Member

SELECT a/nullif(b,0)

Ross Leishman

Thu, 28 September 2006 06:05

Frank
Messages: 7880
Registered: March 2000

Senior Member

ah, those little gems you keep forgetting about!

Thu, 28 September 2006 06:49

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Ditto.
Learning experience - check.

Previous Topic:	retrieving values from objects
Next Topic:	Working with elements in a concatenated field

Goto Forum:

]

Current Time: Thu Aug 17 14:32:03 CDT 2017

Total time taken to generate the page: 0.05074 seconds