Home » SQL & PL/SQL » SQL & PL/SQL » replace column data wserching tab (oracle 9i)
replace column data wserching tab [message #346617] Tue, 09 September 2008 02:40 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member

I Have one table ORDER

in that one column data is like
order
ABCtab)xyz
SDF(tab)rty
'
'
'
'inthis way
I want to remove the data from column where tab is occuring till the last ..
so that data will be as

ABC
SDF....in this way .
Which function I use to remove that data .in sql
Re: replace column data wserching tab [message #346618 is a reply to message #346617] Tue, 09 September 2008 02:44 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Quote:
Which function I use to remove that data .in sql



TRANSLATE



Regards,
Oli
Re: replace column data wserching tab [message #346619 is a reply to message #346617] Tue, 09 September 2008 02:44 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
INSTR

tab is CHR(9).

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Tue, 09 September 2008 02:56]

Report message to a moderator

Previous Topic: ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist
Next Topic: How to convert select stmt into update
Goto Forum:
  


Current Time: Mon Dec 05 10:55:04 CST 2016

Total time taken to generate the page: 0.08061 seconds