Advertisement
Guest User

Untitled

a guest
May 3rd, 2015
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE modificar_sueldo(pdni VARCHAR2,nuevo_sueldo NUMBER)
  2. AS
  3. BEGIN
  4.   IF existir_dni(&pdni)=TRUE
  5.     THEN UPDATE EMPLEADO SET sueldo=nuevo_sueldo;
  6.   ELSE
  7.     DBMS_OUTPUT.PUT_LINE('El dni introducido no existe');
  8.   END IF;
  9. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement