Data types syntax
- Last Updated: November 9, 2022
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
The following demonstrates the supported syntax for data types supported in functions and
procedures. Note that any data type supported by the driver is supported in a function or
procedure. See "Data types" for more information on data types supported by the driver.
BigInt |
Binary(ll)|
Boolean |
Char(ll)|
Date |
Decimal(pp, ss)|
Double |
Float |
GUID |
Integer |
JSON |
LongVarBinary(ll)|
LongVarChar(ll)|
NVarChar(ll)|
SmallInt |
Time((t))|
Timestamp((t))|
TinyInt|
VarBinary(ll)|
VarChar(ll)where:
- ll
- is a value from
1to99that specifies the length of the field. - pp
- is a value from
1to99that specifies the precision of the field. - ss
- is a value from
1to99that specifies the scale of the field. - t
- is a value from
1to9number of digits in the fractional seconds value of the field.