Home » RDBMS Server » Server Administration » Re: converting null value to zero
Re: converting null value to zero [message #373674] Tue, 01 May 2001 10:51
Rajiv
Messages: 14
Registered: April 2001
Junior Member
you can use the decode function when you write the query.
decode(field, null,0,field)

Report message to a moderator

Previous Topic: Re: how to save an image into a table ?
Next Topic: Re: Avoiding 'Group By / Having'
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 09 18:37:44 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.