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: 65085
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: Sun Jul 23 16:14:57 CDT 2017

Total time taken to generate the page: 0.20068 seconds