[SQL] Cursor

hi guys...........

 

This my cursor

 
DECLARE
var varchar(15); 
  cursor1 CURSOR FOR select codigo_uni as codigo
            from recorrido
            where estado='V';
 
BEGIN
 open cursor1;
 
var=cursor1.codigo;
END;
 

It's almost 200 records,

but, I not unknow how read  record for record, I need found one record specific,

 

Excuse me  my english, no write nothing goog, I'm from ecuador.

 

Or explain how, I use the loop, while,  in my function declarated.

Please, more guides....

 

Thanks................