What is ROWID explain ?

Answers were Sorted based on User's Feedback



What is ROWID explain ?..

Answer / kishor potu

ROWID is the pesudo column the oracle it can create in built. it is the hexa decimal data type(it contain alpha numaric number). it contain length is 18 digits. there ROWID in a table must be unique. if you drop the row the ROWID will remove. if any new record enter into the table ROWID assigns a unique number that record.
if you want to see the rowid
select rowid from table_name;

Is This Answer Correct ?    2 Yes 0 No

What is ROWID explain ?..

Answer / pullagura8

ROWID is the physical location of a row. Consequently it is the fastest way of locating a row

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More ETL Interview Questions

What is staging area referring to?

0 Answers  


Explain me ETL project architecture in Detail?

0 Answers   Infosys,


what are the facilities provided by OLAP to analytical users?

1 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  






what is the difference between cardinality and Nullability?

0 Answers  


Is apache nifi an etl tool?

0 Answers  


1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


what are the different Reporting and ETL tools available in the market?

3 Answers  


What is lookup table in etl testing?

0 Answers  


Can there be sub steps of etl steps?

0 Answers  


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


Categories