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 vote132 views1 answer
Sqlplus change user
SQL
1 vote133 views1 answer
Backup mysql data only
SQL
0 vote199 views1 answer
Mysql update all record removing 2 hours from column
SQL
2 votes142 views1 answer
Postgresql create schema in specific database
SQL
2 votes139 views1 answer
Create delete procedure mysql
SQL
-1 vote136 views2 answers
Full join sql
SQL
0 vote129 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote141 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote134 views2 answers
Select index table oracle
SQL
24 votes125 views4 answers
How to add column sql
SQL