Home / Oracle
Oracle functions in Snowflake, Databricks and BigQuery
Oracle functions and syntax with their Snowflake, Databricks and BigQuery equivalents: ADD_MONTHS, DECODE, DUAL, LISTAGG, NVL, ROWNUM, SYSDATE, TO_CHAR.
Checklists: Oracle to Snowflake · Oracle to Databricks · Oracle to BigQuery
NULL handling
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| NVL | Replace NULL with a value | Same name | Same name | Different name |
Conditional logic
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| DECODE | Map values (switch) | Same name | Same name | Rewrite |
Date and time
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| ADD_MONTHS | Add months to a date | Same name | Same name | Rewrite |
| SYSDATE | Current date and time | Same name | Rewrite | Rewrite |
Aggregate
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| LISTAGG | Concatenate values of a group | Same name | Same name | Different name |
Conversion and formatting
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| TO_CHAR | Format a date or number as text | Same name | Rewrite | Rewrite |