Home » SQL & PL/SQL » SQL & PL/SQL » Regular Expressions
icon5.gif  Regular Expressions [message #189430] Thu, 24 August 2006 10:04 Go to next message
sabrieker
Messages: 8
Registered: August 2006
Location: turket
Junior Member
hello i have a problem that is

update migros_source2 set adres=replace(adres,regexp_substr(Adres_apt_adi,'([[:print:]]*)'),'')
ADRES
MERKEZ MAH NAMIK KEMAL CAD OZARI SOK KOC APT AVCILAR
ADRES_APT_ADI
KOC APT


at this code i want to delete adres_apt_adi is confirmed by regexp_substr from adres coloumn
how can i do this
anybody help me
Re: Regular Expressions [message #189455 is a reply to message #189430] Thu, 24 August 2006 12:38 Go to previous messageGo to next message
scottwmackey
Messages: 505
Registered: March 2005
Senior Member
update migros_source2 set adres=replace(adres,Adres_apt_adi,null)
Re: Regular Expressions [message #189528 is a reply to message #189455] Fri, 25 August 2006 00:47 Go to previous message
sabrieker
Messages: 8
Registered: August 2006
Location: turket
Junior Member
thanks
it is working:D
Previous Topic: find column name of specific value in a table (200 columns)
Next Topic: string problem
Goto Forum:
  


Current Time: Wed Dec 07 22:21:24 CST 2016

Total time taken to generate the page: 0.14603 seconds