OraFAQ Forum: SQL & PL/SQL

Tue, 19 February 2002 02:21

M.Satyanarayana
Messages: 1
Registered: February 2002

Junior Member

how can we get spelling of a number through sql statement if a number is given as input
eg: if input is 100 then output should be hundred.

Tue, 19 February 2002 02:51

dhanraj
Messages: 12
Registered: February 2002

Junior Member

You should have to write a Function to get it.

Tue, 19 February 2002 03:48

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

select to_char(to_date(100,'j'),'jsp') from dual;

Previous Topic:	rows into a fix no.of column report ?
Next Topic:	Subqueries

Goto Forum:

]

Current Time: Sat Apr 20 00:05:22 CDT 2024