2020

Details about the releases of Snowflake SnowConvert for Oracle during 2020.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Release 0.2.7

SnowConvert Core 1.9.1

Added

• Support for INTERVAL expression.

• Warnings added when unknown data types, operators and expressions are found.

• Error statement added to the views with missing dependencies.

• Overall improvements in the issues' names and codes.

• Added support for conversion of SELECT... FROM table_name TABLE(...)

Fixed

• Several stability bugfixes for large conversions.

• Identifiers with special characters are correctly converted

• macOS - the Start Over button was causing unexpected behavior.

Release 0.2.4

SnowConvert Core 1.9.0

Added

• New Functions translation: RANK, DENSE_RANK, EMPTY_BLOB, EMPTY_CLOB

• Be able to parse procedure and some procedure statements such as OPEN, CLOSE, FETCH, FOR LOOP, FORALL, CONTINUE, NULL, etc...

Known Issue: macOS - the Start Over button can cause unexpected behavior.

Release 0.2.2

Added

• CREATE Synonyms translation

• Add warning for ROWNUM, ROWID, JSON_TABLE and XML related functions like XMLSEQUENCE, EXTRACTVALUE, EXTRACT (XML)

• Translate new functions like: CAST, LISTAGG, NLSSORT, UNISTR, CHR, SUBSTR

• Translate AT TIME ZONE expression

Release 0.2.0

Added

• Convert more built-in Functions:

  • FIRST and LAST

  • ORA_HASH

  • TO_CHAR

  • REGEXP_REPLACE

  • TO_CLOB

  • TO_TIMESTAMP

  • TO_TIMESTAMP_TZ

• Convert WITH CLAUSE

• Convert unsupported built-in functions that require manual effort to a STUB function

Release 0.1.4

Added

• Convert CREATE TABLE

• Convert basic data types such as NVARCHAR, VARCHAR2, CLOB, INTERVAL YEAR, INTERVAL MONTH, LONG, NUMBER, RAW, ROWID, TIMESTAMP

• Convert CREATE VIEW

• Convert SELECT

• Convert the following Functions: (for all the functions, if there are something that doesn't have an equivalence in snowflake, we may add a WARNING to the output code)

  • REGEXP_REPLACE

  • REGEXP_SUBSTR

  • TO_CLOB(character)

  • TO_CLOB(bfile | blob)

  • TO_CHAR(Date)

  • TO_CHAR (Number)

  • TO_DATE

  • TO_TIMESTAMP

  • TO_TIMESTAMP_TZ

  • TO_NUMBER

  • CAST

  • SYS_CONTEXT

  • CUBE_TABLE

  • TRIM

  • MONTHS_BETWEEN

  • INSTR