<div>
Sounds awesome! Thanks. I won't be able to try it until tomorrow. Thanks.
</div>


Sounds awesome! Thanks. I won't be able to try it until tomorrow. Thanks.

<div>
<div class="content wysiwyg-content">
Suppose I have a table with two columns named ID, and UserName. When the table is first created ID will have all zeroes in it.<br />
Example:<br />
0 &nbsp; &nbsp; Barry<br />
0 &nbsp; &nbsp; Mary<br />
0 &nbsp; &nbsp; Jane<br />
0 &nbsp; &nbsp; Dan<br />
<br />
How would I update this table so that is would add 1 to each value in the ID column starting from the first record in the table. So the end result would look like below. <br />
<br />
1 &nbsp; &nbsp;Barry<br />
2 &nbsp; &nbsp;Mary<br />
3 &nbsp; &nbsp;Jane<br />
4 &nbsp; &nbsp;Dan
</div>
</div>


Suppose I have a table with two columns named ID, and UserName. When the table is first created ID will have all zeroes in it.
Example:
0     Barry
0     Mary
0     Jane
0     Dan

How would I update this table so that is would add 1 to each value in the ID column starting from the first record in the table. So the end result would look like below. 

1    Barry
2    Mary
3    Jane
4    Dan

How to update a column with increment in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.