Senarios for Queries

 

1. Top 5 rows (employees)  from each department in a single query

use Row_Number()over(partition by dept_id ) Then Filter

2.  ALL / ANY > Query

https://oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql

3. Update a partition key value.

It is not possible to update partition key column value. We need to first enable table movement.

Alter table table name enable movement;

Now we can update the key value column.