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)
WhereNNN
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