Home » SQL & PL/SQL » SQL & PL/SQL » anybody help me i have 2 problem
icon4.gif  anybody help me i have 2 problem [message #189862] Mon, 28 August 2006 03:12
Messages: 8
Registered: August 2006
Location: turket
Junior Member
hello i need your help
here my code
select adres,adres_koy,regexp_substr
(adres,'(( MAH\.?)|(M\.)|(MH)|(CAD)|(CD)|(CAD\.)|(CDS)|(C\.))?(^[YENIMAHALLE]|^[USK]|^[SASK]|^[KAZASK])?([[:print:]]*)((SOK)|(SK\.)|( SK)|(SOKAK)|(SOKAK\.)|(SOK\.))',
regexp_instr(adres,'(( MAH\.?)|(M\.)|(MH)|(CAD)|(CD)|(CAD\.)|(CDS)|(C\.))')+1)
from migros_source2

here i want to get substring from adres coloumn that is like this:
here i want to get TEMIZ SK. part but my code takes H. TEMIZ SK.
but i dont want to get H. part also i dont want to use replace method because i have half million document
can u help me

or i explain this i want part of adres coloumn which is between MH. and SK. part but my code gives me MH. TEMIZ SK.
i am looking for TEMIZ SK. it isnot important for me MH. part

and why doesnt this one work

update migros_source set adres_belde=regexp_substr(adres_koy,'([[:print:]]*) CAD')
where regexp_like(adres_koy,'CAD')

[Updated on: Mon, 28 August 2006 09:20]

Report message to a moderator

Previous Topic: ORA-06532: Subscript outside of limit
Next Topic: negative value
Goto Forum:

Current Time: Sun Aug 20 10:42:00 CDT 2017

Total time taken to generate the page: 0.06936 seconds