PL/SQL Fundamentals Exercises with Solution

PL/SQL Fundamentals[16 exercises with solution]

1. Write a PL/SQL block to calculate the incentive of an employee whose ID is 110.

Sample table: employees

2. Write a PL/SQL block to show an invalid case-insensitive reference to a quoted and without quoted user-defined identifier.

Click me to see the solution

3. Write a PL/SQL block to show a reserved word can be used as a user-define identifier.

Click me to see the solution

4. Write a PL/SQL block to show the result to neglect double quotation marks in reserved word identifier.

Click me to see the solution

5. Write a PL/SQL block to show the result to neglect the case sensitivity of a user defined identifier which is also a reserved word.

Click me to see the solution

6. Write a PL/SQL block to explain single and multiline comments.

Click me to see the solution

7. Write PL/SQL blocks to show the declaration of variables.

Click me to see the solution

8. Write PL/SQL blocks to show the scope and visibility of local and global identifiers.

Click me to see the solution

9. Write a PL/SQL block to show a valid case-insensitive reference to a quoted and without quoted user-defined identifier.

Click me to see the solution

10. Write a PL/SQL block to adjust the salary of the employee whose ID 122.

Sample table: employees

Click me to see the solution

11. Write a PL/SQL block to show the operator precedence and parentheses in several more complex expressions.

Click me to see the solution

12. Write a PL/SQL block to create a procedure using the "IS [NOT] NULL Operator" and show AND operator returns TRUE if and only if both operands are TRUE.

Click me to see the solution

13. Write a PL/SQL block to create a procedure using the "IS [NOT] NULL Operator" and show OR operator returns TRUE if either operand is TRUE.

Click me to see the solution

14. Write a PL/SQL block to create a procedure using the "IS [NOT] NULL Operator" and show NOT operator returns the opposite of its operand, unless the operand is NULL.

Click me to see the solution

15. Write a PL/SQL block to describe the usage of NULL values in equal comparison, unequal comparison and NOT NULL equals NULL comparison.

Click me to see the solution

16. Write a PL/SQL block to describe the usage of LIKE operator including wildcard characters and escape character.

Click me to see the solution