Here is the 4 Key Difference between ROWID and ROWNUM : ROWID and ROWNUM are two different concepts used in Oracle databases, and they serve different purposes:
| RowId | RowNum |
| A globally unique identifier for a row in a database. It is created at the time the row is inserted into a table, and destroyed when it is removed from a table.’BBBBBBBB.RRRR.FFFF’ where BBBBBBBB is the block number, RRRR is the slot(row) number, and FFFF is a file number. | For each row returned by a query, the ROWNUM pseudo column returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on. You can use ROWNUM to limit the number of rows returned by a query, as in this example: SELECT * FROM employees WHERE ROWNUM < 10; |
| Rowid is an oracle internal id that is allocated every time a new record is inserted in a table. This ID is unique and cannot be changed by the user. | Row-num is a row number returned by a select statement. |
| Rowid is permanent. | Row-num is temporary. |
| Rowid is a globally unique identifier for a row in a database. It is created at the time the row is inserted into the table, and destroyed when it is removed from a table. | The row-num pseudocoloumn returns a number indicating the order in which oracle selects the row from a table or set of joined rows. |
Also Read :
1. What is the difference between Informatica PowerCenter and Informatica Cloud?
2.What is a Synchronization task in Informatica?
3.What is a Runtime environment in Informatica?
4.What is Check In Check Out in Informatica powercenter (Versioning)
Informatica interview questions and answers | Informatica interview questions and answers