SwisSQL API (Java) Edition - Oracle to Teradata conversion
SwisSQL API (Java) Edition - A multi-dialect SQL parser and conversion engine, supports conversion of Oracle SQLs to Teradata SQLs. It enables Java/J2EE application to input Oracle SQL to SwisSQL API, which understands the input SQL and converts it to equivalent Teradata SQL. The converted target Teradata SQL is returned to Java/J2EE application.
Supported SQL Statements:
CREATE Tables and Views
INSERT
SELECT
UPDATE
DELETE
TRUNCATE
Following Oracle Built-In Functions are supported:
CEIL
CONCAT
CONVERT and CAST
CUME_DIST
DECODE
DENSE_RANK
FIRST_VALUE
GREATEST
GROUPING_ID
HEXTORAW
INSTR and INSTRB
LAG
LAST_VALUE
LEAD
LEAST
LENGTH
LENGTHB
LTRIM
Modulo function
NTILE
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL2
POWER
RATIO_TO_REPORT
REPLACE
RTRIM
SIGN
STDDEV
SUBSTR and SUBSTRB
SYSDATE
SYSTIMESTAMP
TO_CHAR
TO_DATE
TO_TIMESTAMP_TZ , FROM_TZ
TRANSLATE
TRUNC
VARIANCE
Other supported Oracle Syntaxes:
Hierarchical clause in SELECT statements.
SET operators in SELECT statements.
ROWNUM clause in SELECT statements.
Partitioned outer join in SELECT statements.
WITHIN GROUP clause in aggregate and analytic functions.
IGNORE NULLS in ORDER BY clause.
NULL sorting in ORDER BY clause.
KEEP (DENSE_RANK) clause in analytic functions.
Teradata reserved words in Oracle SQLs are quoted.
