Skip to main content

Pl/SQL Program of cursor


declare
student_name student.stu_name%type;
student_roll student.stu_roll%type;
cursor mycursor is select stu_name,stu_roll from student where stu_roll=16378;

begin
 open mycursor;
  loop
  fetch mycursor into student_name, student_roll;
  exit when mycursor%notfound;
  dbms_output.put_line(student_name ||' ' ||student_roll);
  end loop;
  close mycursor;
  end;

Comments

Popular posts from this blog

Pl/SQL program to find square of a user input number Using Function

declare   value1 number;   value2 number;   mytotal number;   function myfun(myval1 in number, myval2 in number) return number is     total number;   begin     total := myval1 ** myval2;     dbms_output.put_line(total);     return total;   end; begin   value1 :=&val1;   value2 := &val2;  mytotal:= myfun(value1, value2); end;