Home » SQL & PL/SQL » SQL & PL/SQL » Can you pls give sql query for a little complex functionality
Can you pls give sql query for a little complex functionality [message #19958] Sun, 21 April 2002 20:12 Go to next message
Amarnath Revuri
Messages: 3
Registered: April 2002
Junior Member
How i can write an SQL query which results the currency value( or
number) in words. For example: if the query "SELECT SAL FROM EMP WHERE
EMPNO = 1234" results a value of 7890.
The 7890 should be displayed as "SEVEN THOUSAND AND EIGHT HUNDRED NINTY".
Note:- One should use only SQL queries but not PL/SQL programming.

Thanks,
Amarnath Revuri

Report message to a moderator

Re: Can you pls give sql query for a little complex functionality [message #19967 is a reply to message #19958] Mon, 22 April 2002 02:40 Go to previous message
to_numbers
Messages: 1
Registered: April 2002
Junior Member
try this :

SELECT to_char(to_date(SAL,'J'),'Jsp' ) FROM
EMP WHERE your_condition

Report message to a moderator

Previous Topic: where are the tables get created by default
Next Topic: How to tune SQL Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 11:38:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.