Learn how to use Oracle ROWID and ROWNUM with this comprehensive tutorial.

Опубликовано: 26 Май 2023
на канале: Anish kumar

2,015

ROWNUM and ROWID are both used to identify a specific row in a table, but they have different meanings and usage.

ROWNUM is a pseudo column used in Oracle databases, which assigns a unique row number to each row in the result set of a query. The row number starts at 1 for the first row, and increments by 1 for each subsequent row. ROWNUM is assigned to the result set after all other operations in the query, including sorting and filtering, have been performed.

ROWID is a physical address of a row in an Oracle table. It uniquely identifies a specific row in the table, and it is guaranteed to remain the same even if the row is updated. ROWID is useful when you need to refer to a specific row in a table without using a primary key or unique constraint.

For more Information Visit:
https://asrblogger.com/
Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/db-scripts

#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba