Home » SQL & PL/SQL » SQL & PL/SQL » Trim (Oracle 10g)
Trim [message #350705] Fri, 26 September 2008 00:04 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
I am getting input data like 2000.00 as varchar and i need to
change into 2000.Sometime i may get 2000.0.so anyway i need to change into 2000 only.Kindly suggests.
Re: Trim [message #350713 is a reply to message #350705] Fri, 26 September 2008 00:44 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
INSTR can give you the position of ".".
SUBSTR can give you a substring.

Other way: REGEXP_SUBSTR

Other way: TO_NUMBER followed by TO_CHAR

All these functions in SQL Reference

Regards
Michel
Previous Topic: Error in Trigger
Next Topic: Comparing null strings
Goto Forum:
  


Current Time: Tue Dec 06 06:37:24 CST 2016

Total time taken to generate the page: 0.06446 seconds