Learn what the ROW_NUMBER function is, how to use it, and what are some use cases and limitations for DBAs who need to manipulate and analyze data with SQL queries.

When you use SELECT in a PL/SQL block, it’s important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.