sql cursor read data into a variable - Cacher Snippet

10/14/2019 - 5:59 AM

sql cursor read data into a variable

[sql cursor read] #sql

cursor-read.sql

/* Example
OPEN c1;
FETCH c1 INTO siteID;
CLOSE c1;
*/

FETCH [ NEXT [ FROM ] ] cursor_name INTO variable_list;