Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- PROCEDURE moverEmpleadoProcedure( idEmp NUMERIC, idDepa NUMERIC )
- IS BEGIN
- UPDATE empleado SET id_dep = idDepa, salario = salario + salario * 2 / 100 WHERE id = idEmp;
- END moverEmpleadoProcedure;
- BEGIN
- moverEmpleadoProcedure( 2, 2);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement