Previous Next JavaScript must be enabled to correctly display this content

## 5.4.12 About Supported Data Types

Learn about supported data types.

Quick SQL supports the following data types:

- `NUMBER`

- `INTEGER`

- `DATE`

- `TIMESTAMP`

- `TIMESTAMP WITH LOCAL TIME ZONE`

- `VARCHAR2(4000)`

- `VARCHAR2(NNN)` Where `NNN` identifies a number between 1 and 32767.

- `VARCHAR2(32767)`

- `CLOB`

- `BLOB`

- `CLOB CHECK (<Column Name> IS JSON)`

Tip:

To learn more about Quick SQL shorthand syntax for supported data types, click Help and select Data Types.

Parent topic: Using Quick SQL