The solutions of PL/SQL challenges for on w3resources executed on Oracle environment compiled with helpful Resources & references related to the challenges.
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
 Eslam Ashraf |
Note: This software is licensed under MIT License, See License for more information ©EslamAsHhraf.