Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> does nvl function work with characters?

does nvl function work with characters?

From: deb <dnanda_at_netcom.ca>
Date: Mon, 19 Apr 1999 18:53:17 -0400
Message-ID: <XMOS2.24024$134.255542@tor-nn1.netcom.ca>


hi,
just wanted to know if nvl function can work with characters.....because i tried to substitute null values with the word 'not available' but it didnot work.it replaces the null value with '0' but doesnot insert characters. Received on Mon Apr 19 1999 - 17:53:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US