daily pastebin goal
36%
SHARE
TWEET

Untitled

a guest Oct 23rd, 2018 92 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. PACKAGE scope_demo
  2. IS
  3. g_global NUMBER;
  4. PROCEDURE set_global (number_in IN NUMBER);
  5. END scope_demo;
  6. PACKAGE BODY scope_demo
  7. IS
  8. PROCEDURE set_global (number_in IN NUMBER)
  9. IS
  10. l_salary NUMBER := 10000;
  11. l_count PLS_INTEGER;
  12. BEGIN
  13. <<local_block>>
  14. DECLARE
  15. l_inner NUMBER;
  16. BEGIN
  17. SELECT COUNT (*)
  18. INTO l_count
  19. FROM employees
  20. WHERE department_id = l_inner AND salary > l_salary;
  21. END local_block;
  22. g_global := number_in;
  23. END set_global;
  24. END scope_demo;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top