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

Term: VARCHAR

Definition:
The VARCHAR data type is actually a subtype of VARCHAR2, with the same range of values found in VARCHAR2. VARCHAR is currently synonymous with VARCHAR2. Use of VARCHAR offers compatibility with ANSI and IBM relational databases.

Oracle strongly recommends that you avoid using VARCHAR and standardize on using VARCHAR2 to declare variable-length PL/SQL variables and table columns since the possibility exists that VARCHAR's meaning or definition may change in subsequent versions of the ANSI SQL standards.


Also See:
Definition & Examples: VARCHAR2 Data Type
Definition & Examples: CHAR Data Type
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 122 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?