The best replacement for cursor is temp table.


The best alternatives to cursor are rated as following:
★★★★★  temp table
★★★★  stickman
★★★★  pointer
★★★  cursor
★★★  while loop
★★  caret
★★  while
★  insertion point
★  table variable
★  ref cursor
★  mouse pointer
★  resultset
★  bulk collect
★  select into
★  loop
★  dynamic sql
★  select
  bulk collect oracle
  explicit cursor
  temporary table
  select into oracle
  set based
  implicit cursor
  stick figure

Your alternative for cursor is not listed? Suggest!
Speaking about cursor, one probably shouldn't forget about hold.

Other search terms related to cursor and their ratings are:

★★★★★ hold
★★ for loop
★★ hold option
dynamic sql in oracle
loop
parameters in pl sql
hold for
select statement in oracle
hold in db2
for update
for loop in oracle
hold db2
for loop in pl sql
procedure
You have in mind a companion for cursor and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of cursor in all years. Click on graph for more.
cursor
temp table
stickman