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 vote75 views1 answer
Oracle function select into
SQL
0 vote133 views1 answer
Oracle change password expiration policy
SQL
0 vote111 views1 answer
Oracle SQL join three tables and group by column
SQL
5 votes151 views2 answers
Add days in oracle sql
SQL
0 vote115 views1 answer
Sql server port 1434
SQL
0 vote134 views1 answer
Load data infile mariadb slow
SQL
11 votes114 views5 answers
Laravel db facade
SQL
0 vote117 views1 answer
Move table to a different schema
SQL
0 vote107 views1 answer
Update set with inner join oracle
SQL
0 vote163 views1 answer
SQL Server Altering Column to be Unique
SQL