eslamashhraf / pl-sql-challenges

✅ The solutions of PL/SQL challenges on w3resources executed on Oracle environment compiled with helpful Resources & references related to the challenges.

🖥️ PL/SQL Challenges

---

📝 Table of Contents

• 📙 Overview
• 🗳️ Challenges
  • Fundamentals
  • DataType
  • Control Statement
  • Cursor
  • Package
• ✨ Contributors
• 🔒 License

---

📙 Overview

The solutions of PL/SQL challenges for on w3resources executed on Oracle environment compiled with helpful Resources & references related to the challenges.

---

✅ Challenges

Fundamentals

Number	Challenges	Solutions
1	Write a PL/SQL block to calculate the incentive of an employee whose ID is 110. Link	SQL
2	Write a PL/SQL block to show an invalid case-insensitive reference to a quoted and without quoted user-defined identifier. Link	SQL
3	Write a PL/SQL block to show a reserved word can be used as a user-define identifier. Link	SQL
4	Write a PL/SQL block to show the result to neglect double quotation marks in reserved word identifier. Link	SQL
5	Write a PL/SQL block to show the result to neglect double quotation marks in reserved word identifier. Link	SQL
6	Write a PL/SQL block to show single and multiline comments. Link	SQL
7	Write PL/SQL blocks to show the declaration of variables. Link	SQL
8	Write PL/SQL blocks to show the scope and visibility of local and global identifiers. Link	SQL

DataType

Number	Challenges	Solutions
1	Write a PL/SQL block to learn how to declare a character type variable. Link	SQL
2	Write a PL/SQL block to insert data to a table using character type variable. Link	SQL
3	Write a PL/SQL block to differenciate between CHAR and VARCHAR2 datatype. Link	SQL
4	Write a PL/SQL procedure to accepts a BOOLEAN parameter and uses a CASE statement to print Unknown if the value of the parameter is NULL, Yes if it is TRUE, and No if it is FALSE. Link	SQL
5	Write a PL/SQL program to show the upper limit of PLS_INTEGER. Link	SQL
6	Write a PL/SQL program to show the uses of SIMPLE_INTEGER datatype. Link	SQL
7	Write a PL/SQL program to show the uses of an unconstrained subtype, i.e., the same set of values as its base type. Link	SQL
8	Write a PL/SQL program to show the uses of a constrained subtype. Link	SQL

Control Statement

Number	Challenges	Solutions
1	Write a PL/SQL program to arrange the number of two variable in such a way that the small number will store in num_small variable and large number will store in num_large variable. Link	SQL
2	Write a Function to Check/Return whether an input number is even or odd, and execute it.Link	SQL
3	Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY. Link	SQL
4	Write a PL/SQL program to count number of employees in a specific department and check whether this department have any vacancies or not. If any vacancies, how many vacancies are in that department. Link	SQL
5	Write a PL/SQL program to display the description against a grade using CASE statement. Link	SQL
6	Write a PL/SQL program to display the description against a grade using CASE statement with EXCEPTION. Link	SQL

Cursor

Number	Challenges	Solutions
1	Write a program in PL/SQL to display a table based detail information for the employee of ID 149 from the employees table. Link	SQL

Package

Number	Challenges	Solutions
1	Create a Package to includeFunction to Check/Return whether an input number is even or odd and Stored a Stored Procedure to check whether an input date falls on weekend i.e. SATURDAY or SUNDAY	SQL

---

👑 Contributors

Eslam Ashraf

---

🔒 License

Note: This software is licensed under MIT License, See License for more information ©EslamAsHhraf.