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: 64729
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: Fri Apr 28 17:07:32 CDT 2017

Total time taken to generate the page: 0.26326 seconds