Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION varsta(id utilizatori.id_utilizator % TYPE) RETURN int
- IS
- data utilizatori.data_nastere % TYPE;
- timp int ;
- BEGIN
- SELECT data_nastere
- INTO data
- FROM utilizatori
- WHERE id_utilizator = id;
- timp := TRUNC((MONTHS_BETWEEN(SYSDATE, data))/12);
- EXCEPTION
- WHEN NO_DATA_FOUND THEN BEGIN
- RETURN -1;
- END;
- RETURN timp;
- END varsta;
- DECLARE
- old int;
- BEGIN
- old := varsta(1);
- DBMS_OUTPUT.put_line(old);
- END;
Add Comment
Please, Sign In to add comment