Oracle SQL – Subquery Introduction
A SQL Subquery is a select statement that is nested within another SQL.It allow you to use output from one query as input of another...
Tagged: ORACLE
How to grant access to oracle dynamic performance views (v$ views)
Oracle dynamic performance views are used to view current database activity and performance in real time. These dynamic views are starts with v$ and also...
Oracle Data Dictionary Views
Oracle provides set of read only views that provides information about database.In this tutorial we will look into different types of Data Dictionary Views and...
Oracle PL/SQL – SELECT FOR UPDATE Statement
When you execute SELECT FOR UPDATE statement, database acquires row level lock automatically against all the rows in the CURSOR result set. Locks on the...
Oracle SQL Merge Statement
SQL merge will allow you to perform multiple INSERT, UPDATE and DELETE in a single statement. There are certain situation where you may want to...