Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Number to Text Conversion

SQL Number to Text Conversion

From: Colin Sheppard <colin_sheppard_at_hp.com>
Date: Fri, 28 Jan 2000 17:54:41 +0800
Message-ID: <86rp13$9ok$1@ctss92.sgp.hp.com> 





Hello,



I was wondering if you can direct me to some ORACLE PL/SQL code/builtin
function, or a web site that converts a numeric value into text, and/or
vice-versa? For example:



'2972'





would be



'two thousand nine hundred and seventy two'





Thank you for your kind attention and assistance,



Cheers,



Colin Sheppard,


IT Solutions Specialist,


Agilent Technologies,


Singapore.



Received on Fri Jan 28 2000 - 03:54:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US