Translates SQL from one dialect to another
translate translates SQL from one dialect to another.
translate(
sql = "",
targetDialect,
tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
oracleTempSchema = NULL
)sql |
The SQL to be translated |
targetDialect |
The target dialect. Currently "oracle", "postgresql", "pdw", "impala", "sqlite", "netezza", "bigquery", and "redshift" are supported. |
tempEmulationSchema |
Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created. |
oracleTempSchema |
DEPRECATED: use |
This function takes SQL in one dialect and translates it into another. It uses simple pattern
replacement, so its functionality is limited. Note that trailing semicolons are not removed for
Oracle, which is required before sending a statement through JDBC. This will be done by
splitSql.
A character string containing the translated SQL.
translate("USE my_schema;", targetDialect = "oracle")Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.