Chapter: Database Management Systems : SQL & Query Optimization

Data Types in SQL

Database Management Systems - SQL & Query Optimization

Data Types in SQL

String types

CHAR(n) –fixed-length character data, n characters long Maximum length = 2000 bytes

VARCHAR2(n) –variable length character data, maximum 4000 bytes

LONG –variable-length character data, up to 4GB. Maximum 1 per table

Numeric types

NUMBER(p,q) –general purpose numeric data type

INTEGER(p) –signed integer, p digits wide

FLOAT(p) –floating point in scientific notation with p binary digits precision

Date/time type

DATE –fixed-length date/time in dd-mm-yy

Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail

Database Management Systems : SQL & Query Optimization : Data Types in SQL |