Guest User

Untitled

a guest
Aug 19th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE DETERMINE_DAY
  2. IS
  3. BEGIN
  4. IF rtrim(to_char(sysdate, 'DAY')) in ('Saturday','Sunday') THEN DBMS_OUTPUT.PUT_LINE('Today is a Weekend')
  5. ELSE DBMS_OUTPUT.PUT_LINE('Today is a Weekday')
  6. END
  7. END;
  8. /
Add Comment
Please, Sign In to add comment