preventing duplcate rows
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?
Subject
Written By
Posted
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.