Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Why do we use sql constraints?

0 Answers  


What is scalar function?

0 Answers  


Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


What is sql server and ase?

0 Answers  


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  






table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,


What is compound trigger?

0 Answers  


What is sql query limit?

0 Answers  


consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,


what is the difference between nested subquery and correlated subquery?

0 Answers  


How to run pl sql program in mysql?

0 Answers  


How do you remove duplicates without using distinct in sql?

0 Answers  






Categories