Home » PL/SQL MCQs

Choose the correct syntax to declare a constant

19. Choose the correct syntax to declare a constant.

1. constant_name CONSTANT datatype := VALUE;
2. datatype CONSTANT constant_name := VALUE;
3. constant_name CONST datatype =: VALUE;
4. datatype CONSTANT constant_name =: VALUE;

Answer: A) constant_name CONSTANT datatype := VALUE;

Explanation:

The correct syntax to declare a constant is –

constant_name CONSTANT datatype := VALUE;