OraFAQ Forum: SQL & PL/SQL » Regular Expressions

Home » SQL & PL/SQL » SQL & PL/SQL » Regular Expressions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regular Expressions [message #189430]

Thu, 24 August 2006 10:04

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

Report message to a moderator

Re: Regular Expressions [message #189455 is a reply to message #189430]

Thu, 24 August 2006 12:38

scottwmackey
Messages: 515
Registered: March 2005

Senior Member

update migros_source2 set adres=replace(adres,Adres_apt_adi,null)

Report message to a moderator

Re: Regular Expressions [message #189528 is a reply to message #189455]

Fri, 25 August 2006 00:47

sabrieker
Messages: 8
Registered: August 2006
Location: turket

Junior Member

thanks
it is working:D

Report message to a moderator

Previous Topic:	find column name of specific value in a table (200 columns)
Next Topic:	string problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 01:54:16 CST 2024