Advertisement
Guest User

Untitled

a guest
Oct 9th, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. SET SERVEROUTPUT ON
  2. VARIABLE basic_percent NUMBER
  3. VARIABLE pf_percent NUMBER
  4. DECLARE
  5. today DATE := SYSDATE;
  6. tomorrow today%TYPE;
  7. BEGIN
  8. DBMS_OUTPUT.PUT_LINE('Hello World');
  9. DBMS_OUTPUT.PUT_LINE('TODAY IS : ' || today);
  10. tomorrow := today + 1;
  11. DBMS_OUTPUT.PUT_LINE('TOMORROW IS : ' || tomorrow);
  12. :basic_percent := 45;
  13. :pf_percent := 12;
  14. END;
  15. /
  16. PRINT basic_percent
  17. PRINT pf_percent
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement