Interested to Buy Any Domain ? << Click Here >> for more details...
What is ROWID?
- 8 Answers
- 19891 Views
- I also Faced
- E-Mail Answers
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 a record in a database?
how to use 'mysql' to run sql statements? : Sql dba
What is a primary key example?
What is on delete restrict?
Explain about various levels of constraint.
Why use truncate instead of delete?
What is a sql profiler?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
What is union and union all keyword in sql and what are their differences?
List the differences between plsql - function & procedures
How do I edit a stored procedure?
What is plpgsql language?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
