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: SQL
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 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...