Interested to Buy Any Domain ? << Click Here >> for more details...
What is ROWID?
- 8 Answers
- 19644 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 trigger point?
What is a boolean in sql?
Explain the components of sql?
Explain the steps needed to create the scheduled job?
How do you write an inner join query?
what is 'mysqlimport'? : Sql dba
What is varchar sql?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance
What do you understand by pl/sql packages?
what is global variable in pl/sql
How do I run a pl sql program?
What is PL/SQL table ?
-
Oracle (3259) - 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)
