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: Wed Jul 03 10:01:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.