Home » SQL & PL/SQL » SQL & PL/SQL » JSP limitations
JSP limitations [message #444425] Sun, 21 February 2010 23:21 Go to next message
vibhavari
Messages: 19
Registered: October 2009
Junior Member
Hi All,
I am using
SELECT TO_CHAR(TO_DATE((:BILL_VALUE),'J'),'Jsp') FROM sys.dual;
its givinig right result for
1023411->One Million Twenty-Three Thousand Four Hundred Eleven
but if i will change it to
10234111 then this query giving an error
ORA-01830: date format picture ends before converting entire input string.

Is there any limitation or is there any other built in function to get the number to a word.

Regards, Vibhavari






Re: JSP limitations [message #444427 is a reply to message #444425] Sun, 21 February 2010 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 24917
Registered: January 2009
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650

GOOGLE is your friend, but only when you actually use it!
Re: JSP limitations [message #444479 is a reply to message #444425] Mon, 22 February 2010 03:41 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Even On,within this this forum also you can find the similar entries...
http://www.orafaq.com/forum/mv/msg/145764/405527/136607/#msg_405527

sriram Smile
Previous Topic: Delete
Next Topic: Not getting output for other schemas
Goto Forum:
  


Current Time: Sat Oct 01 17:51:55 CDT 2016

Total time taken to generate the page: 0.08841 seconds