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