Advertisement
Archangelpl

Untitled

May 29th, 2019
335
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. create or replace TYPE BODY KSIAZKA AS OBJECT
  2. MEMBER FUNCTION up_cena RETURN NUMBER IS
  3. BEGIN
  4. IF (EXTRACT (YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM d_wyd)) >= 1 THEN
  5. cena := cena * 0.95;
  6. RETURN cena;
  7. END IF;
  8.  
  9. END up_cena;
  10. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement