Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE EMPL_UPD
- (v_employee_id employee.employee_id%TYPE,
- v_employee_phone employee.employee_phone%TYPE,
- v_employee_name employee.employee_name%TYPE,
- v_role_id employee.role_id%TYPE)
- AS
- BEGIN
- UPDATE employee SET employee_phone = v_employee_phone,
- employee_name = v_employee_name,
- role_id = v_role_id
- WHERE employee_id = v_employee_id;
- END;
- BEGIN
- EMPL_UPD(10,'+375866756569','DINKATA DINEV',6);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement