Row ID || Row Num Oracle SQL -Day - 35
In Oracle SQL, the ROWID is a unique identifier assigned to each row in a table. It represents the physical address of the row and is typically used by Oracle internally to access and manage data efficiently. The ROWID can be used to uniquely identify a row within a table.
The ROWID can be used in queries to retrieve a specific row or to update/delete rows based on its value. However, it's important to note that the ROWID is specific to a particular table and may change if the row is physically moved or modified.
--------------------------------------------------------------------------------------------------
In Oracle SQL, ROWNUM is a pseudo-column that represents the sequential number of each row retrieved from a query result. It is often used to limit the number of rows returned or to assign row numbers to the result set. It is essential to understand that ROWNUM is assigned before any sorting is done, so it may not represent the actual order of the rows in the result set.
#oracle #sql #sqlqueries #sqlserver