What is ROWID?
Answers were Sorted based on User's Feedback
Answer / kalyan kumar
The unique value generated bydefault for each and every row
in the column of any table when user inserts records.
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / aasid
A rowid is a pseudo column (like versions_xid), that
uniquely identifies a row within a table, but not within a
database. It is possible for two rows of two different
tables stored in the same cluster to have the same rowid.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / rajesh
ROWID
Every record has a unique ROWID within a database
representing the physical location on disk where the record
lives. Note that ROWID's will change when you reorganize or
export/import a table.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / guest
ROWID Represents phyiscal location on disk for a record.It
is unique Hexadecimal number (like AAAL+ZAAEAAA....)which
get generated automatically at the time of insertion.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / srikanth
It gives the location in the database where row is
physically stored.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / akash lekurwale
row id is the address for each row when it will insert into
the table it is unique even some rows are inserting
duplicate
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sourisengupta
ROW_ID is a pseudo column in each table. This column is
appended by default to every table that is created.You can
dentify each row by this column.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jigar r gor
ROWID is a pseudo column that oracle derives for each record fetched by an implicit SQL query.
Every rowid associated to the data row of a table is dynamically assigned and is not part of the actual user table.
Also the same can be just referred and not be used as sequences.
Is This Answer Correct ? | 1 Yes | 0 No |
What is raid? How does it help storage of databases?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
How to run sql commands in sql*plus?
What is row_number () in sql?
after tell procedure whole code he asked can i write the same way in a function
What is a null value?
What is having clause in sql?
Show code of a cursor for loop.
What is sql query limit?
What is dbo in sql?
What is the difference between jpql and sql?
What is basic structure of pl sql?