Hi Thangasamy,
Can any one send this material.
oracle CRM module material and also material
regarding forms and reports customisation.
Thank you in a Advance
-----Original Message-----
From: Thangasamy S
[mailto:oracledba-ezmlmshield-x5035488.[Email address protected]
Sent: Tuesday, January 31, 2006 8:54 PM
To: LazyDBA Discussion
Subject: RE: Date to Words
Same way any function there to convert numbers (Currency) into words
S. Thangasamy
MIS Manager
*Tel..........: +966 1 2315577 Ext 209
*Fax...........: +966 1 2300022
*Cell.........: +966 503448347
*E-Mail......: [Email address protected]
"Web Site...: www.safari.com.sa
-----Original Message-----
From: Adam Christie-Grant
[mailto:oracledba-ezmlmshield-x2196204.[Email address protected]
Sent: Tuesday, January 31, 2006 3:26 PM
To: LazyDBA Discussion
Subject: RE: Date to Words
Depends how you want it to appear :
select to_char(sysdate,'DAY DD MONTH MON YYYY YY RR YEAR') from dual;
TO_CHAR(SYSDATE,'DAYDDMONTHMONYYYYYYRRYEAR')
------------------------------------------------------------------------
----
----
TUESDAY 31 JANUARY JAN 2006 06 06 TWO THOUSAND SIX
Hope that helps :o)
Adam
-----Original Message-----
From: nsk [mailto:oracledba-ezmlmshield-x62190355.[Email address
protected]
Sent: 31 January 2006 11:51
To: LazyDBA Discussion
Subject: Date to Words
Hi,
Can any one help me to display the date field value in words in a select
query
----- nsk
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
============
DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the addressess(s) named
herein. If you are not the intended recipient or addressee, you should
not use, disseminate, distribute, copy or alter this email. Any views
or opinions presented in this email are solely those of the author and
might not represent those of "Safari Co. Ltd." and or its subsidiaries.
WARNING: The out bound mails are scanned for presence of any viruses but
check this email and any attachments for the presence of viruses. The
company accpts no liability for any damage caused by any virus
transmitted by this email.
MIS Department
Safari Co. Ltd.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page