PL/SQL Programming   «Prev  Next»

Building PL/SQL Naming Convention - Exercise

Objective: Create a naming convention for your application.

Exercise Scoring

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.

Instructions

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

Submitting your Exercise

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.