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 vote193 views2 answers
Sql max count
SQL
5 votes211 views1 answer
Oracle asynchronous query
SQL
1 vote197 views1 answer
Create table variable in sql stored procedure
SQL
2 votes207 views1 answer
Sql find not in list
SQL
0 vote193 views1 answer
Oracle procedure teamplate
SQL
0 vote178 views1 answer
Suse start MySQL
SQL
0 vote198 views1 answer
Sqlalchemy get ids
SQL
0 vote187 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote191 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote183 views1 answer
Add colum date in sql
SQL