Update the local variable

Hi guys,


using the SELECT statement i am retrieving some values from the table along with that i am also taking one local variable.

ex

select emp_age , variable from employee.


in the above query variable is a local variable and i set it to 0.

suppose if the above query selects 5 rows from the table then i expect the following the results.

emp_age variable value

10 1
12 2
13 3
14 4
15 5

please help me to achieve the same thing