🎴 Flashcard Mode

Oracle PL/SQL and SQL Fundamentals

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. What will be the initial value of the variable when the block is executed?

AnswerClick to flip back
A
NULL
💡 Explanation:

In PL/SQL, variables that are declared but not initialized default to NULL when execution begins. They do not default to 0, their default value does not depend on scale/precision, and they can still be used in the executable section.

Change Mode