Advertisement
Guest User

Unlucky

a guest
Apr 26th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.47 KB | None | 0 0
  1. DECLARE
  2.  NUMERO NUMBER := 210;
  3.  SALARIO NUMBER;
  4. BEGIN
  5. SELECT SALAR INTO SALARIO FROM EMPLEADOS WHERE NUMEM=NUMERO;
  6. DBMS_OUTPUT.PUT_LINE ('El salario del empleado número ' || NUMERO || ' es ' || SALARIO || '.');
  7. IF SALARIO >= 1000 THEN
  8. DBMS_OUTPUT.PUT_LINE ('El empleado es mileurista.');
  9. ELSE
  10. DBMS_OUTPUT.PUT_LINE ('El empleado no es mileurista.');
  11. END IF;
  12. EXCEPTION
  13. WHEN NO_DATA_FOUND THEN
  14. DBMS_OUTPUT.PUT_LINE ('No se ha encontrado el número de empleado.');
  15. END;
  16. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement