Re: does nvl function work with characters?

It works perfectly,

insert into temp values(&1,nvl('&2','ok'))...where if &2 is null will insert ok into table otherwise value entered.

Thanks,

Vrajesh Patel.

deb wrote:

> 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 Tue Apr 20 1999 - 17:19:26 CDT