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