Category: Oracle SQL

You often need to fetch a row that has maximum value for a specific column. For example, we have an ORDERS table and we want...

Oracle database has syntax “CREATE TABLE … AS SELECT … “which allows you copy data from one table to another without predefining the target table....

In oracle, you can create Auto Increment column using sequence database object. Using Oracle sequence object you can generate unique value and assign that value...

Oracle database has a pseudo-column named ROWNUM. You can use this ROWNUM in your SQL query to limit the results You can use query like...

You often want to query an oracle database to list out all the tables in a database. In Oracle, there are mainly 3 different types...

SQL WITH Clause was introduced by oracle in oracle 9.2 release. SQL WITH clause also known as subquery factoring. WITH clause will create temporary dataset...

An Inline View is a SELECT statement written in the FROM clause of a query. Inline View are used in ORACLE SQL to simplify complex...

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

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