SHARE
TWEET

Unlucky

a guest Apr 26th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. /
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top