update single column

[kavithared]

Hiii,i have a table it contains 1000 rows,now i like to add a new column as null column.
now i want to update this column numbers from 1,2 --1000.
Is there any method?
if any one know give me example
thanks

[SANJAY_G]

Does the order of the rows matter??

Add new column to the table.

Write a curosr loop to update this column using a counter.


HTH
Sanjay

[kavithared]

hii, i want order 1 t0 1000.
because this table contains some other columns.
this column become serialno column.
so i must eneter values from 1 to 1000.
if possble modify the mine.
thanks

[naag007]

Hi,
Why don't u define a sequence on ur table if u want give serialno from 1,2..1000 to ur table rows?
Raju