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 |
Why do we use sql constraints?
What is scalar function?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
What is sql server and ase?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
What is compound trigger?
What is sql query limit?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
what is the difference between nested subquery and correlated subquery?
How to run pl sql program in mysql?
How do you remove duplicates without using distinct in sql?