I want to write one stored procedure with select statement and i want to traverse through each record as we do in programming using while look. How can i do that.
i.e. say i want to execute sql statement SELECT * FROM <TABLE NAME> and then i want to browse through resultant recordset, one by one record in stored procedure. how can i do that.