preventing duplcate rows
Posted by: Dimitris Papageorgiou
Date: April 06, 2023 01:30AM

Probably this is not so difficult to solve but I have a zero experience and that is why I am asking.

Imagine the following scenario...a user calls a hair salon and the CSR keeps his/her name and phone in a 2-column table(the structure is not important for now)

The name could be for example John Nash...the same person calls again...
The issue is how to prevent duplicate entries in the DB

If the name given the second time is exactly the same letter by letter than a check in the DB would suffice.

But what if the name typed by the CSR is something like John Nas...
This will lead in a second tuple that will refer to the same person though.

How can I avoid that?
Any ideas?

Options: ReplyQuote

Written By
preventing duplcate rows
April 06, 2023 01:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.