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 vote328 views1 answer
Having all mysql
SQL
0 vote322 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
11 votes274 views2 answers
Having keyword sql
SQL
0 vote274 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote292 views1 answer
Incorrect string value: mysql
SQL
0 vote304 views1 answer
What is between keyword used for
SQL
0 vote288 views1 answer
Mysql procedure between two tables
SQL
0 vote283 views1 answer
Not between mysql
SQL
0 vote364 views2 answers
Mysql insert rows to another database
SQL
16 votes286 views6 answers
Insert sql
SQL