RANK and DENSE_RANK
Posted inORACLE

RANK and DENSE_RANK

RANK() : function always returns sequential order for each record.DENSE_RANK() : It returns continuous order for each record. Copy CodeCopiedUse a different BrowserSELECT empno, deptno, sal, mgr, RANK () OVER (PARTITION BY…
April 26, 2017
Handle trigger Mutating Error
Posted inORACLE

Handle trigger Mutating Error

Many times we have faced the problem of trigger Mutating error. error ORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve Create…
April 25, 2017
Posted inORACLE

Constraints in Nested table

In my previous blog “Working With Nested Table Oracle ” I explained how to work with nested tables. Here we can also define Constraints to the nested table. According to the…
April 11, 2017