1 2 Previous Next 17 Replies Latest reply: Oct 18, 2013 5:59 AM by Etbin RSS

    Avoid record creation with similar names

    user7351276

      Hi,

       

      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