Re: NULL value printing problems

paul_at_mx9.com (Paul) wrote in message news:<49213f89.0201091128.39fc2e36_at_posting.google.com>...
> There are some fields that aren't required in an input screen, so
> consequently the Oracle DB stores it as Null. But when I have a JSP
> print out the information, it actually prints out the word null. HOw
> can i have it just print out nothing instead of the word Null, without
> doing things like conditional statements to check it before printing.
> Is there a quick and easy solution?

while selecting the records
use nvl function

select nvl(columnname,'value to be displayed if null encounters') from table

palak Received on Fri Jan 11 2002 - 07:13:22 CET