Block Processing Triggers: Block processing triggers fire in response to events related to record management in a block. ·         ...

Oracle Official Academy Courses sql pl/sql forms reports 1-Oracle Database 10g: Introduction to SQL Course Topics: - Introduc...

Types of Indexes : Oracle Database provides several indexing schemes, which provide complementary performance functionality. The indexe...

select e.empno,e.ename,e.sal from emp e where e.sal > (select m.sal from emp m where m.empno =(select mgr from emp mg where e.empno = ...

SUM Analytic Function This article gives an overview of the SUM analytic function. If you are new to analytic functions you should probabl...

View with Parameter 1-virtual private database context 2-global package variable 3-Lookup Tables #1 Virtual Private Database Context I will...

This article provides a clear, thorough concept of analytic functions and its various options by a series of simple yet concept building ex...