Description Usage Arguments Details Value Examples
translateSql
translates SQL from one dialect to another
1 2 | translateSql(sql = "", sourceDialect = "sql server",
targetDialect = "oracle", oracleTempSchema = NULL)
|
sql |
The SQL to be translated |
sourceDialect |
The source dialect. Currently, only "sql server" for Microsoft SQL Server is supported |
targetDialect |
The target dialect. Currently "oracle", "postgresql", "pdw", and "redshift" are supported |
oracleTempSchema |
A schema that can be used to create temp tables in when using Oracle. |
This function takes SQL in one dialect and translates it into another. It uses simple pattern replacement, so its functionality is limited.
A list containing the following elements:
The original parameterized SQL code
The translated SQL
1 2 3 4 | ## Not run:
translateSql("USE my_schema", "sql server", "oracle")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.