Watch Query Current Session Information via SQL

Posted on
3,650 Points
Last Modified:
Experience Level: Beginner
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Author:Steve Wales
I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.
In this article, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month