Home » SQL & PL/SQL » SQL & PL/SQL » string manipulation
string manipulation [message #360854] Mon, 24 November 2008 02:46 Go to next message
rags11
Messages: 21
Registered: October 2008
Junior Member
hi,
how to remove the first letter in a column value.
for eg i will have , in the begining for each column value and while displaying i want to remove it.
Please let me know if there is any fuction can do this.
Thanks

[EDITED by LF: the original topic title was "straing manipulation"]

[Updated on: Mon, 24 November 2008 05:20] by Moderator

Report message to a moderator

Re: straing manipulation [message #360858 is a reply to message #360854] Mon, 24 November 2008 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UPDATE with SUBSTR

Regards
Michel
Re: straing manipulation [message #360873 is a reply to message #360854] Mon, 24 November 2008 04:03 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

No need to do UPDATE , as the OP want to do manipulation during display .


Quote:
for eg i will have , in the begining for each column value and while displaying i want to remove it.


Use of substr is enough.

Smile
Rajuvan.
Previous Topic: View has erorrs
Next Topic: without orderby clause
Goto Forum:
  


Current Time: Fri Dec 02 20:40:17 CST 2016

Total time taken to generate the page: 0.16138 seconds