What is ROWID?

Answers were Sorted based on User's Feedback



What is ROWID?..

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

What is ROWID?..

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

What is ROWID?..

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

What is ROWID?..

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

What is ROWID?..

Answer / srikanth

It gives the location in the database where row is
physically stored.

Is This Answer Correct ?    3 Yes 1 No

What is ROWID?..

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

What is ROWID?..

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

What is ROWID?..

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

Post New Answer

More SQL PLSQL Interview Questions

what does myisamchk do? : Sql dba

0 Answers  


Why do we use procedures in sql?

0 Answers  


What does sql stand for?

0 Answers  


Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  


What is the difference between sql and mysql?

0 Answers  






List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


Is postgresql a server?

0 Answers  


What is pseudo column ?

6 Answers   ABB,


What are different functions in sql?

0 Answers  


explain access control lists. : Sql dba

0 Answers  


What is trigger price?

0 Answers  


Can we use ddl commands in pl sql?

0 Answers  


Categories