Home » SQL & PL/SQL » SQL & PL/SQL » Miss Match Check (9i Rel 2)
Miss Match Check (9i Rel 2) [message #251515] Fri, 13 July 2007 23:33 Go to next message
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member


Users enter data manually in a table Tab_A.
Tab_A have many columns, each row can be uniquely identified by combination of Col1 and Col2.

To eliminate human error every record enters twice by 2 different users.

Q: what is the best way to get Miss Match Records of users in this situation?

1. Create 2 table of same structure user1 enter in 1st table and user2 in 2nd table then match them?
2. Both users enter in same table then match?
3. Or any other solution?

Did anyone ever create such procedure? Can anyone advise me the best tested solution?


Re: Miss Match Check (9i Rel 2) [message #251518 is a reply to message #251515] Sat, 14 July 2007 00:48 Go to previous message
Michel Cadot
Messages: 63910
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you think and why or why not?

Btw, there is a forum for homework.

Previous Topic: Not Exists or Not in
Next Topic: table or view does not exists
Goto Forum:

Current Time: Mon Oct 24 02:34:25 CDT 2016

Total time taken to generate the page: 0.09542 seconds