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 vote208 views1 answer
Oracle sql drop table
SQL
0 vote244 views1 answer
Influxdb list all tags for a measurement
SQL
7 votes201 views2 answers
Get database size mysql
SQL
0 vote208 views1 answer
Exec procedure oracle
SQL
4 votes197 views2 answers
DB::transaction
SQL
9 votes194 views4 answers
Mysql show table fields
SQL
1 vote203 views1 answer
Mysql query where in select
SQL
0 vote167 views1 answer
Create duplicate table in postgresql
SQL
1 vote170 views2 answers
Show sql logs in spring boot
SQL
0 vote212 views1 answer
Oracle locked objects
SQL