Help Center > > Developer Guide> Syntax Compatibility Differences Between Teradata and Oracle

Syntax Compatibility Differences Between Teradata and Oracle

Updated at: Jul 15, 2020 GMT+08:00

DWS is compatible with Teradata and Oracle syntax, of which the syntax behavior is different.

Table 1 Compatibility differences

Compatibility Item

Teradata

Oracle

Data type DATE

Stores year, month, and day values.

Converts the DATE data type to the TIMESTAMP data type which stores year, month, day, hour, minute, and second values.

Empty string

An empty string is distinguished from a NULL value.

An empty string is treated as a NULL value.

Conversion from an empty string to INT

0

NULL

Automatic truncation of overlong characters

Supported (only if td_compatible_truncation is set to on)

Not supported

VARCHAR + INT calculation

Converts to NUMERIC + NUMERIC calculation.

Converts to BIGINT + INT calculation.

CASE and COALESCE expressions

Is compatible with behavior of Teradata and supports type conversion between digits and strings. For example, if input parameters for COALESCE are of INT and VARCHAR types, the parameters are resolved as VARCHAR type.

Reports error.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel