Number Rows in a Table
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Number Rows in a Table
| Line 1: | Line 1: | ||
| - | Say you have a [[Microsoft SQL Server]] table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In Oracle you would simply update the column with rownum: | + | Say you have a [[Microsoft SQL Server]] table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In [[Oracle Database]] you would simply update the column with rownum: |
<pre> | <pre> | ||
