Home » PL/SQL MCQs

What is/are the Naming Rules for the PL/SQL Variables?

13. What is/are the Naming Rules for the PL/SQL Variables?

1. An ASCII letter must be the first letter in the variable name.
2. In the case of variables, make sure you use easy to read, easy to understand characters after the first character, such as underscore (_) or dollar sign ($).
3. Optionally, the variable can be specified as NOT NULL.
4. All of the above

Answer: D) All of the above

Explanation:

The Naming Rules for the PL/SQL Variables states that –

1. An ASCII letter must be the first letter in the variable name.
2. In the case of variables, make sure you use easy to read, easy to understand characters after the first character, such as underscore (_) or dollar sign ($).
3. Optionally, the variable can be specified as NOT NULL.