Home » SQL & PL/SQL » SQL & PL/SQL » validate address
validate address [message #197114] Tue, 10 October 2006 02:02 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
how do i validate address
say i have
coladdr1= 'sanjaynagar 3 main 4 main blore karnataka india'
it is updated to
coladdr1 = 'jayanagr 10main blore kar india'

i need to validate the text

pls help me

thanxs

Re: validate address [message #197117 is a reply to message #197114] Tue, 10 October 2006 02:07 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, what rules do you need to apply to the text to validate it?
Re: validate address [message #197140 is a reply to message #197117] Tue, 10 October 2006 04:19 Go to previous messageGo to next message
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
Junior Member
you are not mentioned your question properly.
Re: validate address [message #197141 is a reply to message #197114] Tue, 10 October 2006 04:41 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
There is currently a competition in the "Community Hangout" forum to find the vaguest, most badly worded question ever. With this question, I think you've a very good chance of being nominated. What are the rules by which you convert "3 main 4 main" to "10 main" or "sanjaynagar" to "jayanagr" ? Short of mind reading, I don't see how we can work this out.
Re: validate address [message #197203 is a reply to message #197114] Tue, 10 October 2006 08:24 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
update table1 set coladdr1='jayanagr 10main blore kar india'
where coladdr1='sanjaynagar 3 main 4 main blore karnataka india';


QED
Previous Topic: How do i know the tablespace is using the current user?
Next Topic: Time difference report using date range
Goto Forum:
  


Current Time: Sun Dec 04 08:49:16 CST 2016

Total time taken to generate the page: 0.09457 seconds