T sql cursor tr

BEGIN
  DECLARE cur_employee CURSOR FOR
      SELECT Surname
      FROM Employees;
  DECLARE name CHAR(40);
  OPEN cur_employee;
  lp: LOOP
    FETCH NEXT cur_employee INTO name;
    IF SQLCODE <> 0 THEN LEAVE lp END IF;
    ...
  END LOOP;
  CLOSE cur_employee;
END

Source: dcx.sap.com

Similar codes

0 vote343 views1 answer
Install mysql 8 linux
SQL
2 votes411 views1 answer
Creating a view SQL
SQL
3 votes346 views1 answer
Oracle apex warning message
SQL
6 votes349 views5 answers
Alter table oracle
SQL
0 vote422 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
5 votes354 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote342 views1 answer
Components/Fields of Internal Table
SQL
0 vote362 views1 answer
Where field is null sql knex
SQL
8 votes351 views1 answer
Oracle search source code
SQL
0 vote358 views1 answer
Ubuntu connect to mssql database
SQL