2020

Details about the releases of Mobilize.Net SnowConvert for Oracle during 2020.

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