In this article we will check how dependency works with packaged subprogram.
First, we will create a package and then we will call the packaged subprogram through a stand alone procedure.
CREATE OR REPLACE PACKAGE…
If we add any column to the table which is used in a stored procedure then the procedure gets invalidated. But Oracle automatically compiled the invalid object when it is called for execution.
CREATE…
If we add any column to the table which is used in a stored function then the function get invalidated. But Oracle automatically compiled the invalid object when it is called for execution.…
Prior 11g, if we add any column to the base table of a view then the view got invalidated. From 11g onward this problem has been fixed. Oracle automatically compiled the invalid object …
If the definition of object OB1 references object OB2 then OB1 is dependent on OB2. Oracle database automatically track and manages these dependencies. If you alter the definition of reference object OB2 then …
If any table contains hierarchical data then we can select hierarchical rows by using hierarchical queries.
SELECT LEVEL, COLUMN, EXPRESSION.. FROM TABLE [WHERE CONDITION(S)] [START WITH CONDITION(S)] [CONNECT BY PRIOR CONDITION(S)]
| KEYWORD | DESCRIPTION |
|---|---|
| SELECT |
Oracle 10g release 2 introduces a new feature called Conditional compilation. It allows PLSQL compiler to compile a selected parts of a program based on conditions you specify with the $IF directive in PLSQL.
It enables you to …
Before oracle 11g, the PLSQL Compiler translated our source code to system code without applying many changes to improve the performance. But now Oracle PLSQL uses a new optimizing compiler that can rearrange our code for better performance.…
In SQL the order of commands are:
Usually ORDER BY is the last command in SQL. But 11g has introduced …
Privileges are basically rights to access any object or perform any operation through a procedure.
EXECUTE is the object privileges to run a procedure. This includes: