ROWID Pseudo column|Oracle SQL

Published: 09 January 2022
on channel: emahar

#cobol #python #sql

ROWID Pseudo column in Oracle SQL.
For each row in the database, the ROWID pseudocolumn returns the address of the row.
Oracle Database rowid values contain information necessary to locate a row:
■ The data object number of the object
■ The data block in the data file in which the row resides
■ The position of the row in the data block (first row is 0)
■ The data file in which the row resides (first file is 1). The file number is relative to
the tablespace

Rowid values have several important uses:
■ They are the fastest way to access a single row.
■ They can show you how the rows in a table are stored.
■ They are unique identifiers for rows in a table

Learn python, Java, COBOL, C++, Oracle,SQL,PL/SQL,HTML,Javascript, Financial Accounting and many more..

SUBSCRIBE for latest videos and new courses.

#eda #learnskills #learnonline

/ emaharda

/ emahardigitalacademy

Watch video ROWID Pseudo column|Oracle SQL online without registration, duration hours minute second in high quality. This video was added by user emahar 09 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 76 once and liked it 1 people.

422