Skip to main content

PL/SQL PRogram Of Cursor



declare
  e_id    employee.employee_id%type;
  e_first employee.first_name%type;
  e_last  employee.last_name%type;
  cursor e_cursor is
    select employee_id, first_name, last_name from employee;

begin
  open e_cursor;
  loop
    fetch e_cursor
      into e_id, e_first, e_last;
       exit when e_cursor%notfound;
    dbms_output.put_line('employee id :'
                         || e_id || 'employee first name is : ' ||
                         e_first || 'employee last name is : ' ||e_last);
  end loop;
  close e_cursor;
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;