Example 9-5 Separating Cursor Specifications With Packages

CREATE PACKAGE emp_stuff AS
   CURSOR c1 RETURN employees%ROWTYPE;  -- declare cursor spec
END emp_stuff;
/
CREATE PACKAGE BODY emp_stuff AS
   CURSOR c1 RETURN employees%ROWTYPE IS
      SELECT * FROM employees WHERE salary > 2500;  -- define cursor body
END emp_stuff;
/