Re: Urgent Help

From: Mark Merritt <none_at_your.domain.here.com>
Date: 2000/03/12
Message-ID: <ApSy4.324$w_2.2018@pravda.msen.com>#1/1

select initcap(to_char(to_date('150', 'J'), 'JSP')) from dual;

Works for numbers within the range of valid Julian dates.

Sarah <sarah_jessicaNOsaSPAM_at_hotmail.com.invalid> wrote:
: How can I convert number to character in Oracle.
: Ex.
: select comm from emp;
: Output
: comm
: ----
: 100
: 150

: Now I want to output as
: Comm
: ----
: One Hundred
: One Hundred and Fifty

: I tried with these
: Select to_char(comm) from emp;
: but this is gone in vain.

: Thanks
: Sarah
Received on Sun Mar 12 2000 - 00:00:00 CST