This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Oct 18, 2013 3:59 AM by Etbin RSS

Avoid record creation with similar names

user7351276 Newbie
Currently Being Moderated



am trying to add a validation in Oracle forms using Oracle DB.

in a Oracle table consider there is a record named 'Netbook' then if I try to create another record with name 'Netbooks', then a Oracle warning message should be displayed stating similar name 'Netbook' is already available. same way, if NETBOOKS is already available in table and if user try to create another record NETBOOK then same warning message netbooks is already available should be shown.


Is this possible, please could you let me know and how this can be acheived.

1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points