Home » PL/SQL MCQs

The correct syntax to declare PL/SQL variable is –

10. The correct syntax to declare PL/SQL variable is –

1. variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]
2. datatype [CONSTANT] variable_name [NOT NULL] [:= | DEFAULT initial_value]
3. variable_name [CONSTANT] datatype [NULL] [:= | DEFAULT initial_value]
4. datatype [CONSTANT] variable_name [NULL] [:= | DEFAULT initial_value]

Answer: A) variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]

Explanation:

The correct syntax to declare PL/SQL variable is –

variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]