Generating Records based on frequency

We actually save the requestids in a table called TABLE_KEYS and we increment the requestid in that table

Below is the logic i used in my cursor query to update the TABLE_KEYS .How can i do this in your query

update table_keys

set key_id = key_id + 1

where table_name = 'adhoc'

---

Vamsi