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 |
Note: This software is licensed under MIT License, See License for more information ©EslamAsHhraf.
