What is ROWID?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different schemas objects that can be created using pl/sql?

527


Do we need commit after truncate?

613


Is oracle sql free?

540


How does rowid help in running a query faster?

970


what is text? : Sql dba

561






What is %s in sql?

564


What is data profiling in sql?

515


explain commit and rollback in mysql : sql dba

547


Can you selectively load only those records that you need? : aql loader

614


What is the use of double ampersand (&&) in sql queries? Give an example

613


Why is pl sql used?

527


What are the indexing methods?

574


what is 'mysqladmin' in mysql? : Sql dba

534


How do I view stored procedures?

543


What are string functions in sql?

678