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.