1  create or replace function DETAILS(stid in number , endid in number) return
  2  sys_refcursor as
  3  details sys_refcursor
  4  begin
  5  open details for
  6  select * from student where id>=stid and id<=endid;
  7* end;