Built-in functions
This section shows equivalents between functions in Oracle and in Snowflake.
| Oracle | Snowflake | Notes |
|---|---|---|
ABS | ABS | |
ACOS | ACOS | |
ADD_MONTHS | ADD_MONTHS | |
ANY_VALUE | ANY_VALUE | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
APPROX_COUNT | *to be defined | |
APPROX_COUNT_DISTINCT | APPROX_COUNT_DISTINCT | |
APPROX_COUNT_DISTINCT_AGG | *to be defined | |
APPROX_COUNT_DISTINCT_DETAIL | *to be defined | |
APPROX_MEDIAN | *to be defined | |
APPROX_PERCENTILE | APPROX_PERCENTILE | |
APPROX_PERCENTILE_AGG | *to be defined | |
APPROX_PERCENTILE_DETAIL | *to be defined | |
APPROX_RANK | *to be defined | |
APPROX_SUM | *to be defined | |
ASCII | ASCII | |
ASCIISTR | *to be defined | |
ASIN | ASIN | |
ATAN | ATAN | |
ATAN2 | ATAN2 | |
AVG | AVG | |
BFILENAME | *to be defined | |
BIN_TO_NUM | *to be defined | |
BITAND | BITAND | |
BIT_AND_AGG | BITAND_AGG | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
BITMAP_BIT_POSITION | BITMAP_BIT_POSITION | |
BITMAP_BUCKET_NUMBER | BITMAP_BUCKET_NUMBER | |
BITMAP_CONSTRUCT___AGG | BITMAP_CONSTRUCT___AGG | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
BITMAP_COUNT | BITMAP_BIT_COUNT | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
BITMAP_OR_AGG | BITMAP_OR___AGG | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
BIT_OR_AGG | BIT_OR_AGG | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
BIT_XOR_AGG | BIT_XOR_AGG | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
CARDINALITY | *to be defined | |
CAST | CAST TO_DATE TO_NUMBER TO_TIMESTAMP Not Supported | The function is converted to stub 'CAST_STUB' and outputs an error, when comes with one of the following not supported statement: 'DEFAULT ON CONVERSION ERROR' or 'MULTISET'. Also, it is converted to a stub and outputs an error if the data type is not supported. The function is converted to the 'TO_NUMBER' function when the expression to cast is of type number and outputs an error indicating that the explicit cast is not possible to be done. The function is converted to the 'TO_DATE' function when the expression to cast is of type date and outputs an error indicating that the explicit cast is not possible to be done. The function is converted to the 'TO_TIMESTAMP' function when the expression to cast is of type timestamp and outputs an error indicating that the explicit cast is not possible to be done. |
CEIL | CEIL | |
CHARTOROWID | *to be defined | |
CHECKSUM | *to be defined | |
CHR | CHR | USING NCHAR_CS statement is not supported by the Snowflake function equivalent. The clause is removed. |
CLUSTER_DETAILS | *to be defined | |
CLUSTER_DISTANCE | *to be defined | |
CLUSTER_ID | *to be defined | |
CLUSTER_PROBABILITY | *to be defined | |
CLUSTER_SET | *to be defined | |
COALESCE | COALESCE | |
COLLATION | COLLATION | |
COLLECT | *to be defined | |
COMPOSE | *to be defined | |
CON_DBID_TO_ID | *to be defined | |
CON_GUID_TO_ID | *to be defined | |
CON_NAME_TO_ID | *to be defined | |
CON_UID_TO_ID | *to be defined | |
CONCAT | CONCAT | Every expression parameter will be inside of an NVL(expr, ' ') function to avoid an error in case one of the expressions is null. |
CONVERT | *to be defined | |
CORR | CORR | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
CORR_S | *to be defined | |
CORR_K | *to be defined | |
COS | COS | |
COSH | COSH | |
COUNT | COUNT | |
COVAR_POP | COVAR_POP | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
COVAR_SAMP | COVAR_SAMP | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
CUBE_TABLE | Not Supported | Converted to a stub 'CUBE_TABLE_STUB' and an error is added. |
CUME_DIST | CUME_DIST | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
CURRENT_DATE | CURRENT_DATE | |
CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | |
CV | *to be defined | |
DATAOBJ_TO_MAT_PARTITION | *to be defined | |
DATAOBJ_TO_PARTITION | *to be defined | |
DBTIMEZONE | *to be defined | |
DECODE | DECODE | |
DECOMPOSE | *to be defined | |
DENSE_RANK | DENSE_RANK | There are two kinds of syntax, aggregate syntax, and analytic syntax. The aggregate syntax is not supported and an error is added. The analytic syntax is supported but the 'SIBLINGS' keyword is removed from the 'order by' clause and a warning is added. |
DEPTH | *to be defined | |
DEREF | *to be defined | |
DUMP | *to be defined | |
EMPTY_BLOB | *to be defined | |
EMPTY_CLOB | *to be defined | |
EXISTSNODE | *to be defined | |
EXP | EXP | |
EXTRACT (datetime) | EXTRACT (datetime) Not supported | Kept as an EXTRACT function but outputs a warning when the function has 'MINUTE' or 'TIMEZONE_MINUTE' as the first keyword parameter. Converted to a stub 'EXTRACT_STUB' and outputs an error when the first keyword parameter is 'TIMEZOME_REGION' or 'TIMEZONE_ABBR' |
EXTRACT (XML) | Not Supported | Function related to XML is not supported. It is converted to a stub 'EXTRACT_STUB' and an error is added. Please check the following link about how to handle the loading for XML: |
EXTRACTVALUE | Not Supported | Converted to a stub 'EXTRACTVALUE_STUB' and an error is added. |
FEATURE_COMPARE | *to be defined | |
FEATURE_DETAILS | *to be defined | |
FEATURE_ID | *to be defined | |
FEATURE_SET | *to be defined | |
FEATURE_VALUE | *to be defined | |
FIRST | Not Supported | The statement used to indicate that only the first or last values of the aggregate function will be returned is not supported. Outputs an error. |
FIRST_VALUE | FIRST_VALUE | A warning is being added to indicate the Snowflake counterpart may not be functionally equivalent. |
FLOOR | FLOOR | |
FROM_TZ | *to be defined | |
GREATEST | GREATEST | |
GROUP_ID | *to be defined | |
GROUPING | GROUPING | |
GROUPING_ID | GROUPING_ID |