Category: SQL

Oracle 12c new features (Part – 2)

We have covered Top N queries and Invisible columns in Oracle 12c New Features (Part – 1) In this article, we will learn: Session-Level Sequences Cascading Truncate DDL Logging Identity Columns Multiple Index 3....

Oracle 12c new features (Part – 1)

In this article, we will learn the top Oracle 12c new features for developers. Top N Queries: This is a way of limiting the number of rows returned to the first ‘N’ meeting the...

Order By clause in Oracle : Must Know

In this article, we will learn what a developer should know about Order by clause in Oracle. When multiple columns/expressions are specified in the ORDER BY clause, the precedence of sorting is left to...

PseudoColumns in Oracle

In this article, we will learn PseudoColumns in oracle. A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update,...

Reset a sequence in Oracle

In oracle, there is no built in commend to reset sequence.So we can look at a work around to reset sequence using a procedure. create or replace procedure reset_sequence(p_seq in varchar2) is     l_value number;...