Guest User

Untitled

a guest
Aug 20th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.52 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION varsta(id utilizatori.id_utilizator % TYPE) RETURN int
  2. IS
  3. data utilizatori.data_nastere % TYPE;
  4. timp int ;
  5.     BEGIN
  6.     SELECT data_nastere
  7.     INTO data
  8.     FROM utilizatori
  9.     WHERE id_utilizator = id;
  10.     timp := TRUNC((MONTHS_BETWEEN(SYSDATE, data))/12);
  11.  
  12. EXCEPTION
  13.     WHEN NO_DATA_FOUND THEN BEGIN
  14.                             RETURN -1;
  15.                             END;
  16. RETURN timp;
  17. END varsta;
  18.  
  19.  
  20. DECLARE
  21.  
  22. old int;
  23.  
  24. BEGIN
  25.  
  26. old := varsta(1);
  27.  
  28. DBMS_OUTPUT.put_line(old);
  29. END;
Add Comment
Please, Sign In to add comment