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.…
We can compile Triggers through many ways.
To identify uncompiled Triggers we have to query USER_OBJECTS data dictionary view.
Identifying complete list …
We will check in this article possible ways to convert a Ref cursor to a Table.
We need to create a setup to test the scenario.
First we will create a package to get …
We will create two packages to test the calling.
1st Package: PKG_EMP_DATA
This package will extract information about employees of a specific department.
--Queries…
In this article we will see how to fetch multiple columns and rows from a cursor.
We will check 3 ways to fetch multiple columns from a cursor:
Function 1: This will take employee_id and a string as parameters and return employee's salary or total salary, average salary, maximum salary, minimum salary of …
We can use trigger to restrict insertion of duplicate values in a table in Oracle.
But there is a challenge to create trigger on the table itself.
Oracle …
We can use Trigger to restrict data insertion into employees table.
In the below example we will write a trigger which will restrict data insertion of an employee who has …