I have a requirement where i need to replicate the for loop functionality through sql query.In pl/sql i can achieve this through cursors or for loop but is there any way to do or replicate the same functionality in sql queries .
For example i want to repeat the operation for set of records or iterate through set of records and fire query accordingly .Is it possible through sql query