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 limitations of identity column? : Transact sql

826


what are the differences between char and nchar? : Sql dba

801


What is procedure and function?

684


What is the location of pre_defined_functions.

846


Why should I use postgresql?

770






What are the two parts of design view?

774


What is cursor in pl sql with examples?

676


What does stand for in sql?

720


How do you pronounce sql?

733


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

736


Can we use join in subquery?

781


how do you know the version of your mysql server? : Sql dba

692


How does sql developer connect to oracle database?

747


Why partition by is used in sql?

732


Is sql a backend?

773