Home » RDBMS Server » Server Administration » Re: converting null value to zero
Re: converting null value to zero [message #373676] Tue, 01 May 2001 12:14
Lee
Messages: 56
Registered: May 1999
Member
There is an Oracle function that is built specialy for this, NVL().

NVL(NULL_COL, 0)

Report message to a moderator

Previous Topic: Re: Avoiding 'Group By / Having'
Next Topic: Forcing an index in a query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 09:00:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.