Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 1 Oracle SQL Basics
  5. 1.3.5 Variables

1.3.5 Variables

A variable is declared by giving a name and data type. Data type determines the size and the range of values that can be stored within the variable and the set of operations that can be applied to the variable.

The name of a variable consists of letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters. By default, variable names are not case-sensitive.

You cannot use a reserved keyword as a variable name.

A variable declaration specifies its name, data type, and value, and allocates storage for it. The declaration can also impose the NOT NULL constraint.

Was this article helpful to you? Yes No

How can we help?