Explore PL/SQL Object-Oriented Programming Exercises

PL/SQL OOP [ 6 exercises with solution ]

1. Write a PL/SQL code to create a class for a "Person" with attributes such as name, age, and address.

Click me to see the solution

2. Write a PL/SQL code to Implement methods in the "Person" class to display the details and update the age.

Click me to see the solution

3. Write a PL/SQL code to implement a method to calculate the annual bonus based on the salary in the "Employee" class.

Click me to see the solution

4. Write a PL/SQL code to create a "Manager" subclass inheriting from the "Employee" class, and add an attribute to store the number of employees managed.

Click me to see the solution

5. Write a PL/SQL code to create a "Shape" class with attributes like length and width, and implement a method to calculate the area.

Click me to see the solution

6. Write a PL/SQL code that implement a method in the "Shape" class to determine if the shape is a square or not.

Click me to see the solution