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.
2. Write a PL/SQL code to Implement methods in the "Person" class to display the details and update the age.
3. Write a PL/SQL code to implement a method to calculate the annual bonus based on the salary in the "Employee" class.
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.
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.
6. Write a PL/SQL code that implement a method in the "Shape" class to determine if the shape is a square or not.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics