Building PL/SQL Naming Convention - Exercise

This exercise is worth a total of 15 points. You will receive up to 8 points (2 for each datatype) for declaring a variable for each datatype with the correct syntax. You will receive up to 7 points for explaining the standards that you build for these datatypes.

Define a dummy local variable for each of the following datatypes and explain the naming conventions that you have followed for them:

1. VARCHAR2
2. DATE
3. BOOLEAN
4. NUMBER

Once you have defined the datatypes and added your explanation for the naming convention, place it in the text area below and click the Submit button.