Tuesday, March 21, 2017

employee id already exits



DECLARE
    v varchar2(6);
BEGIN
    SELECT EMP_ID INTO V FROM EMP_MAST WHERE EMP_ID=:emp_mast.EMP_ID;
    IF V >0 THEN
        MESSAGE('Employee ID Already Exist !!');
        MESSAGE('Employee ID Already Exist !!');   
    else
        next_field;
    end if;
    exception when others then raise form_trigger_failure;
       
end;

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...