Home » SQL & PL/SQL » SQL & PL/SQL » How to remove fixed number of characters from a text data type
How to remove fixed number of characters from a text data type [message #193348] Fri, 15 September 2006 16:06 Go to next message
bnath001
Messages: 10
Registered: September 2006
Junior Member
I am new to oracle.

I have a text data type column that has 5 characters in the end.
I do not need them. How can I exclude those 5 characters and update the same field (without 5 characters)?

thanks
nath
Re: How to remove fixed number of characters from a text data type [message #193351 is a reply to message #193348] Fri, 15 September 2006 16:17 Go to previous message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
SUBSTR function
Previous Topic: Post data in AP interface table
Next Topic: TRUNCATE TABLE
Goto Forum:
  


Current Time: Mon Dec 05 06:45:05 CST 2016

Total time taken to generate the page: 0.05420 seconds