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 vote152 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote151 views1 answer
Oracle query archivemode
SQL
0 vote152 views1 answer
Will graphql replace sql
SQL
0 vote167 views1 answer
What is top n result in sql
SQL
-1 vote154 views1 answer
Can pandas fetch data from sql
SQL
2 votes159 views1 answer
Postgresql create schema in specific database
SQL
0 vote174 views2 answers
MySQL PARTITION BY month automatically
SQL
1 vote159 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
1 vote147 views1 answer
Oracle sql listagg
SQL
0 vote155 views1 answer
Apex for oracle 11g
SQL