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
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

Hi

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?

i.e.
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?

Thanks
Jawad

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: 64139
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.

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


Current Time: Thu Dec 08 14:43:23 CST 2016

Total time taken to generate the page: 0.08539 seconds