rowid and rownumber in sql | oracle | Difference between rowid and row_number
In this video tutorial, we discuss the pseudo column rowid and rownum in oracle sql. After watching this video you would be able to understand the basic difference between rowid and a rownum pseudo columns of oracle database.
Rowid returns the exact location of the row in the database, hence whenever you retrive a record based on rowid, it is the fastest retrival possible.
Whereas for each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows.
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Install python packages
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru
![Wet Hands - Minecraft (Piano Tutorial) // [Synthesia]](https://images.videosashka.com/watch/Z7ZkOTDyVeE)
