Use of SQL cursors-cursor FOR loop small example _mssql

Example: Displays all employee names and their salaries for the EMP table:

Copy Code code as follows:

Declare
Cursor Emp_cursor is select ename,sal from EMP;
Begin
For Emp_record in Emp_cursor loop
Dbms_output.put_line (' Name: ' | | emp_record.ename| | ', wages: ' | | Emp_record.sal);
End Loop;
End;
/

Anonymous block completed
Name: SMITH, Salary: 880
Name: ALLEN, Salary: 1600
Name: WARD, Salary: 1250
Name: JONES, Salary: 3272.5
Name: MARTIN, Salary: 1250
Name: BLAKE, Salary: 2850
Name: CLARK, Salary: 2450
Name: SCOTT, Salary: 2000
Name: KING, Salary: 5000
Name: TURNER, Salary: 1500
Name: ADAMS, Salary: 1210
Name: JAMES, Salary: 950
Name: FORD, Salary: 3300
Name: MILLER, Salary: 2100