MANAGING DEPENDENCY WITH PACKAGED SUBPROGRAM
MANAGING DEPENDENCY WITH PACKAGED SUBPROGRAM In this article we will check how dependency works with… Read More
1 year ago
SQL
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
1 year ago
IMPACT OF CHANGING REFERENCED OBJECT ON FUNCTIONS
IMPACT OF CHANGING REFERENCED OBJECT ON FUNCTIONS If we add any column to the table… Read More
1 year ago
IMPACT OF CHANGING REFERENCED OBJECT ON VIEW
IMPACT OF CHANGING REFERENCED OBJECT ON VIEW Prior 11g, if we add any column to… Read More
1 year ago
MANAGING DEPENDENCIES IN ORACLE
MANAGING DEPENDENCIES IN ORACLE WHAT IS DEPENDENCY? If the definition of object OB1 references object… Read More
1 year ago
HIERARCHICAL QUERIES
HIERARCHICAL QUERIES If any table contains hierarchical data then we can select hierarchical rows by… Read More
1 year ago
FILTER AFTER ORDER BY CLAUSE IN ORACLE
FILTER AFTER ORDER BY CLAUSE IN ORACLE Sequence of Commands in Oracle In SQL the… Read More
2 years ago
OBJECT PRIVILEGES FOR PROCEDURE IN ORACLE
OBJECT PRIVILEGES FOR PROCEDURE IN ORACLE Privileges are basically rights to access any object or… Read More
2 years ago
OBJECT PRIVILEGES FOR VIEWS IN ORACLE
OBJECT PRIVILEGES FOR VIEWS IN ORACLE Privileges are basically rights to access any object or… Read More
2 years ago
OBJECT PRIVILEGES FOR TABLE IN ORACLE
OBJECT PRIVILEGES FOR TABLE IN ORACLE Privileges are basically rights to access any object or… Read More
2 years ago