Here's an example to get you going: DECLARE l_race_rec race%rowtype; CURSOR Query1 IS SELECT * FROM RACE WHERE Race_Time ...
stackoverflow.com