You should create and Use this table to help you : category. (catNo , catogeryName) By using PL/SQL: Create procedure to add new Category which use validation FUNCTION checkExistingCategory using EXCEPTION to validate category name if its not exists before, then add this category and generate the category number automatically using database trigger. ((Don't forget to use exception ))