PLSQL: PACKAGES

Write a package specification and body to display "Hello Oracle".

(Package Basic Structure)

Create a package with one procedure to display employee details.

(Package + Procedure)

Create a package containing a function to return square of a number.

(Package + Function)

Write a package with both procedure and function.

(Package Structure)

Create a package to group employee-related operations.

(Package Design)

Create a package with a global variable and display its value.

(Package Variable)

Write a package to store company name as constant and display it.

(Package Constant)

Create a package that uses a variable to count number of procedure calls.

(Package State Management)

Write a package with a global variable used in multiple procedures.

(Shared Variable in Package)

Create a package procedure to fetch employee details using empno.

(Package Procedure)

Create a package procedure to insert employee record.

(Package + INSERT)

Create a package procedure to update employee salary.

(Package + UPDATE)

Create a package procedure to delete employee record.

(Package + DELETE)

Create a package procedure to increase salary of all employees by 10%.

(Package + Business Logic)

Create a package function to return employee salary.

(Package Function)

Create a package function to return total employees.

(Package + Aggregate Function)

Create a package function to return maximum salary.

(Package + Aggregate Function)

Create a package function to calculate bonus (10% of salary).

(Package Function + Logic)

Create a package that uses cursor to display all employees.

(Package + Cursor)

Create a package with parameterized cursor to fetch employees by department.

(Package + Parameterized Cursor)

Create a package procedure that loops through employees using cursor FOR LOOP.

(Package + Cursor Loop)

Create a package with private procedure (only in body, not in specification).

(Private vs Public in Package)

Create a package with overloaded procedures (same name, different parameters).

(Procedure Overloading)

Create a package with function overloading.

(Function Overloading)

Create a package to maintain employee audit logs.

Create a package with initialization block (executed once).

(Package Initialization)

Create a package to perform all CRUD operations on EMP table.

(Full Package Design)

Create a package that calculates salary, bonus, and tax using multiple functions.

(Business Logic Package)

Create a package to validate employee data before insert/update.

(Validation Logic)

Create a package that interacts with multiple tables (EMP, DEPT).

(Multi-table Package)

Create a package to simulate banking operations (deposit, withdraw, balance check).

Create a package that uses exception handling for all operations.

(Exception Handling in Package)