-
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
kavitha
-
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
-
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
kavitha
-
define a sequence
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|