Simple Cursor Example

declare project_cur cursor for
select project_name from project_master where project_name is Not null;
open project_cur 
fetch next from project_cur 
while @@fetch_status = 0
begin
   fetch next from project_cur 
end
close project_cur 
deallocate project_cur