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

11 votes227 views1 answer
Mysql text type max length
SQL
0 vote224 views1 answer
Mysql update table from select on another table
SQL
6 votes223 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote217 views1 answer
Oracle select first result
SQL
2 votes205 views1 answer
Docker run postgres locally
SQL
0 vote208 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote221 views1 answer
SQL Server Enterprise
SQL
-1 vote232 views1 answer
Auto increment psql not primary key
SQL
2 votes229 views1 answer
Oracle convert run_duration to number
SQL
1 vote224 views2 answers
Postgresql truncate cascade restart identity
SQL