Database » Ask Tom MOST RECENT ARTICLES » Display the number value in Words

Feeds

15126 items (76 unread) in 26 feeds

Database (76 unread)

• DBA's notes (6 unread)
• $Pete Finnigan's Oracle security weblog (1 unread)
• Ask Tom MOST RECENT ARTICLES (30 unread)
• Databases News (3 unread)
• DBAzine.com - Oracle Articles Archive
• Eddie Awad's Blog (2 unread)
• FeuerThoughts
• Mark Rittman's Oracle Weblog
• MR. ED's blog
• MySQL Performance Blog (9 unread)
• Niall's Oracle Pages
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions
• Oracle Security Alerts
• Oracle Software Downloads
• Oracle Technology News
• Oracle's OTN TechCasts (2 unread)
• Orawin.Info
• OTN TechBlog
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (1 unread)
• TheServerSide.com (22 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• May 12, 2008
• 

  Display the number value in Words

  Fetched: May 12th, 2008, 6:45pm PDT

  Tags:    [edit]

  <code>To Display the number value in Words i am using this query i am giving this example RO2003@BDAPPRD.SGP.HP.COM> select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp; And the output is SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP'...