Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Variables In Oracle      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: VARIABLE

Definition:
A variable is a portion of memory that contains a value. A value can be any kind of information, e.g. names, numbers, text, sounds, images, etc.

A variable's value can change, depending on what is stored in the memory location by functions or by commands running within a program.

A variable declaration specifies the variable's name, data type, and value, and allocates the initial amount of storage for it.

The declaration can also assign an initial value to the variable and enforce the NOT NULL constraint.

Note that variables are initialized every time a block or subprogram is entered. By default, variables are initialized to NULL.

Whether public or private, variables declared within a package specification are initialized only once for each session.

An initialization clause is required when declaring NOT NULL variables. If you use %ROWTYPE to declare a variable, initialization is not allowed.


Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 106 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?