Re: Simple SQL statement

From: Buck Turgidson <sam_i_am_jcman_at_worldnet.att.net>
Date: Sun, 10 Sep 2000 01:58:06 GMT
Message-ID: <OUBu5.1838$M37.119172@bgtnsc07-news.ops.worldnet.att.net>

See the NVL function in the Oracle SQL Reference.

cycloid1 <cycloid1_at_alltel.net> wrote in message news:8peo29$2da$1_at_iac5.navix.net...
> Hi all,
>
> I am in the beginning phases of learning the SQL language. I'm taking the
> intro to Oracle class and I've run into a snag. I'm trying to write a
simple
> statement that will convert a null that exists in a column with a numeric
> datatype to a character string. In other words, if it encounters a null
> (numeric column) I need it to spit out "No Commission". Does the DECODE
> function allow you to convert from on datatype to another? I can't get
> TO_CHAR to work either. I'm sure it's a syntax thing. Thanks in advance
for
> any help!
>
>
Received on Sat Sep 09 2000 - 20:58:06 CDT