daily pastebin goal


a guest Jun 13th, 2018 46 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. declare
  2.   cursor cur_prop is
  3.     select prop_name, qcid from property;
  4.     where qcid <= 50
  5.   r_prop cur_prop%ROWTYPE;
  6. begin
  7.   open cur_prop;
  8.   loop
  9.     fetch cur_prop into r_prop;
  10.   exit when cur_prop%NOTFOUND
  11.   end loop;
  12.   close cur_prop;
  13. end;
  14. /
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