Variable

From Oracle FAQ
Jump to: navigation, search

A variable is a programmer-defined name used to hold information in a program.

[edit] PL/SQL Example

Define a variable v_cnt in a PL/SQL program:

DECLARE 
  v_cnt NUMBER;  -- Define a number variable
BEGIN
  v_cnt := 0;
  WHILE v_cnt < 10 LOOP
    v_cnt := v_cnt + 1;
  END LOOP;
END;
/

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #