Home » SQL & PL/SQL » SQL & PL/SQL » Compare records (
Compare records [message #383339] Wed, 28 January 2009 06:20 Go to next message
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I have 2 tables A and B.
 Table A
Eno  Ename
1     Mike
2     Isherr
3     Frank
4     lucy
5     lilli

Table B
Eno  Ename
1    Micke
2    isher
3    franck
4    rak
5    lilly

Now the requirement is these teo tables having the same structure. Now I want to compare those tables records with the data. There is some change in Ename eg: Mike-Micke these are pronouncing equally. But there is difference in spelling. like this the records which are there in table A not available in Table B.
so now I want to retrieve( or highlight) those unavailable records and the pronounciation different records.
can you please give me idea to write a query or Procedure/function or any..

Thank you.

[EDITED by LF: fixed [code] tags]

[Updated on: Wed, 28 January 2009 06:54] by Moderator

Report message to a moderator

Re: Compare records [message #383341 is a reply to message #383339] Wed, 28 January 2009 06:25 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For difference, it is easy use MINUS in both way.
For pronunciation, search here for some pointers. Nothing is provided by Oracle by SOUNDEX function.

Previous Topic: SQL query help
Next Topic: How to Create a Password?
Goto Forum:

Current Time: Tue Oct 25 12:41:14 CDT 2016

Total time taken to generate the page: 0.06306 seconds