PL/SQL

write an anonymous block program unit that insert a user-input values into employees table and print a message 'record is inserted successfully' as following:

Employee_id: user-input

Last name : user-input

First_name: user-input

Department_number: user-input

Manager_id : user-input ( nullable)

The program raises an exception if "dup_val_on_index" and print the message "department number is duplicated".

Try two cases:

Input values (employee_id:110, last_name : Bandarus, first_name: Prakash, department_number : 3, Manager_id:8)

Input values (employee_id: 8, last_name : Mark, first_name: Smith, department_number : 8, Manager_id:Null)