Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE modificar_sueldo(pdni VARCHAR2,nuevo_sueldo NUMBER)
- AS
- BEGIN
- IF existir_dni(&pdni)=TRUE
- THEN UPDATE EMPLEADO SET sueldo=nuevo_sueldo;
- ELSE
- DBMS_OUTPUT.PUT_LINE('El dni introducido no existe');
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement