sayan_bappa@yahoo.co.in

MANAGING DEPENDENCY WITH PACKAGED SUBPROGRAM

MANAGING DEPENDENCY WITH PACKAGED SUBPROGRAM In this article we will check how dependency works with… Read More

IMPACT OF CHANGING REFERENCED OBJECT ON PROCEDURE

IMPACT OF CHANGING REFERENCED OBJECT ON PROCEDURE If we add any column to the table which… Read More

IMPACT OF CHANGING REFERENCED OBJECT ON FUNCTIONS

IMPACT OF CHANGING REFERENCED OBJECT ON FUNCTIONS If we add any column to the table… Read More

IMPACT OF CHANGING REFERENCED OBJECT ON VIEW

IMPACT OF CHANGING REFERENCED OBJECT ON VIEW Prior 11g, if we add any column to… Read More

MANAGING DEPENDENCIES IN ORACLE

MANAGING DEPENDENCIES IN ORACLE WHAT IS DEPENDENCY? If the definition of object OB1 references object… Read More

HIERARCHICAL QUERIES

HIERARCHICAL QUERIES If any table contains hierarchical data then we can select hierarchical rows by… Read More

CONDITIONAL COMPILATION

CONDITIONAL COMPILATION Oracle 10g release 2 introduces a new feature called Conditional compilation. It allows… Read More

The Ultimate Guide to PLSQL Compiler

PLSQL COMPILER Before oracle 11g, the PLSQL Compiler translated our source code to system code… Read More

FILTER AFTER ORDER BY CLAUSE IN ORACLE

FILTER AFTER ORDER BY CLAUSE IN ORACLE Sequence of Commands in Oracle In SQL the… Read More

OBJECT PRIVILEGES FOR PROCEDURE IN ORACLE

OBJECT PRIVILEGES FOR PROCEDURE IN ORACLE Privileges are basically rights to access any object or… Read More