Advertisement
Guest User

Untitled

a guest
May 3rd, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.48 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION PROBLEMA14(f1 DATE, f2 DATE)
  2.                                RETURN NUMBER
  3. IS
  4.    anyos NUMBER;
  5.    meses NUMBER;
  6. BEGIN
  7.    meses:=MONTHS_BETWEEN(f1, f2);
  8.    anyos:=meses/12;
  9.    anyos:=TRUNC(anyos,0);
  10.    IF (anyos<0) THEN
  11.       anyos:=anyos*(-1);
  12.    END IF;
  13.    RETURN anyos;
  14. END;
  15. /                              
  16.  
  17. SELECT PROBLEMA14(SYSDATE,'03/05/2000')
  18. FROM DUAL;
  19.  
  20. DECLARE
  21. res NUMBER;
  22. BEGIN
  23. res:=problema14(SYSDATE,'03/05/2000');
  24. DBMS_OUTPUT.PUT_LINE(res);
  25. END;
  26. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement