PL/SQL Exercises with Solution

Introduction

The best way we learn anything is by practice and exercise questions. We have started this section for those (beginner to intermediate) who are familiar with SQL and Oracle. Exercises are designed to enhance your ability to write well-structured PL/SQL programs. Hope, these exercises help you to improve your PL/SQL query skills. Currently following sections are available, we are working hard to add more exercises. Happy Coding!

• PL/SQL Fundamentals [ 16 Exercises ]
• PL/SQL DataType [ 8 Exercises ]
• PL/SQL Control Statement [ 30 Exercises ]
• PL/SQL String Functions [ 12 Exercises ]
• PL/SQL While Loop [ 21 Exercises ]
• PL/SQL Cursor [ 50 exercises ]
• PL/SQL Trigger [ 11 exercises ]
• PL/SQL Exception Handling [ 16 exercises ]
• PL/SQL Package [ 17 exercises ]
• PL/SQL Object-Oriented Programming [ 6 exercises ]