OraFAQ Forum: Training & Certification » code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to

Home » Other » Training & Certification » code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320177]

Wed, 14 May 2008 04:36

amritaseema
Messages: 47
Registered: January 2008

Member

Hi All,
i want a code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_date function)

I tried using to_date and showing the o/p till 99...
DECLARE
v_number VARCHAR2 (20);
BEGIN
SELECT TO_CHAR (TO_DATE (&n, 'J'), 'JSP')
INTO v_number
FROM DUAL;

DBMS_OUTPUT.put_line ('The number is :' || v_number);
END;

bt now i want it without using any functions.plzz help me out.

Thanks in adavance
Seema

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320180 is a reply to message #320177]

Wed, 14 May 2008 04:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Write your own code.

Regards
Michel

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320196 is a reply to message #320180]

Wed, 14 May 2008 05:10

amritaseema
Messages: 47
Registered: January 2008

Member

i am not getting it....
i got it using the to_char and to_date function as i mentioned above...

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320199 is a reply to message #320196]

Wed, 14 May 2008 05:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes but if you don't want to use built-in functions then you have to write your own code.

Regards
Michel

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320260 is a reply to message #320196]

Wed, 14 May 2008 07:52

Frank
Messages: 7901
Registered: March 2000

Senior Member

amritaseema wrote on Wed, 14 May 2008 12:10

i am not getting it....
i got it using the to_char and to_date function as i mentioned above...

I am not getting it either.
Why don't you want to use the only appropriate functions available?

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320312 is a reply to message #320260]

Wed, 14 May 2008 11:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Why don't you want to use the only appropriate functions available?

Because teacher asked to do so. Wink

Regards
Michel

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320580 is a reply to message #320312]

Thu, 15 May 2008 10:05

amritaseema
Messages: 47
Registered: January 2008

Member

because i want to know how we can write it without using prdefine function... Confused

Report message to a moderator

Re: code to display string of numbers in words(Ex: 321 as Three Two One); (Please don't use to_d [message #320588 is a reply to message #320580]

Thu, 15 May 2008 10:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Well, what did you think/find/try till now?

Regards
Michel

Report message to a moderator

Previous Topic:	program to print the number of occurrence of a particular letter in a word.
Next Topic:	pl/sql block to determine the top employees

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 09:29:31 CST 2024