From: "cycloid1" <cycloid1@alltel.net>
Newsgroups: comp.databases.oracle.misc
Subject: Simple SQL statement
Date: Sat, 9 Sep 2000 21:28:26 -0400
Organization: Navix Internet Subscribers
Lines: 12
Message-ID: <8peo29$2da$1@iac5.navix.net>
NNTP-Posting-Host: r-237.141.alltel.net
X-Trace: iac5.navix.net 968549257 2474 166.102.237.141 (10 Sep 2000 01:27:37 GMT)
X-Complaints-To: abuse@navix.net
NNTP-Posting-Date: 10 Sep 2000 01:27:37 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300


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!