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 |
Can a table contain multiple primary key’s?
Can we use view in stored procedure?
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
What does the hierarchical profiler does?
Why do we use procedures in pl sql?
How do I send sql query results to excel?
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
How can you create Cursor with parametres ?
what is the command used to fetch first 5 characters of the string? : Sql dba
what is “go” in t-sql? : Transact sql
What is schema in sql example?
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.