Oracle SQL : How to fetch a row that has the maximum value for a column
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...
Tagged: ORACLE
How to copy data from one table to another on Oracle?
Oracle database has syntax “CREATE TABLE … AS SELECT … “which allows you copy data from one table to another without predefining the target table....
How to create Auto Increment column in Oracle
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...
How to limit the number of rows returned by a Query in Oracle
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...
How to get list of all tables in oracle
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...
Oracle SQL – WITH Clause
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...
Oracle SQL – Inline View
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...
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...