Home » SQL & PL/SQL » SQL & PL/SQL » Suppress zero with a blank
Suppress zero with a blank [message #1475] Sun, 05 May 2002 00:45 Go to next message
Venu
Messages: 44
Registered: September 1999
Member
How to suppress a zero with a blank in oracle report tools like browser and discoverer

Report message to a moderator

Re: Suppress zero with a blank [message #1508 is a reply to message #1475] Tue, 07 May 2002 08:46 Go to previous message
motiram
Messages: 21
Registered: January 2001
Junior Member
select decode(column,0,'',column) from table

Does this answer you?

Report message to a moderator

Previous Topic: Re: Employee who earns the highest salary
Next Topic: how to create cluster?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 14:56:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.