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: 65143
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: Fri Aug 18 05:58:42 CDT 2017

Total time taken to generate the page: 0.85968 seconds