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

I faced problem when i update the header of form which give me FRm-40656 Record has been updaetd by another User Requery to see chages an...

Situation When installing Oracle 11g release 2 (32 bit) software on Windows or RHEL5.2 at step: "Copy files.... In progress...

The " ORA - 01033 : ORACLE   initialization   or   shutdown in progress ." error can also happen when Oracle is attempting startu...