Answer / kalyan kumar

The unique value generated bydefault for each and every row
in the column of any table when user inserts records.

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.

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.

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.

Answer / srikanth

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

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

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.

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.

What is a table?

0 Answers  

Does user triggers have entry for trigger with compilation errors?

0 Answers  

How exception handling is done in advance pl/sql?

0 Answers  

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

What is a join?

0 Answers  

what is sp_pkeys? : Transact sql

0 Answers  

What is embedded sql in db2?

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

How many types of tables are there?

0 Answers  

What are the datatypes available in pl/sql ?

0 Answers  

what is an index? : Sql dba

0 Answers