Getting Started (LEGACY)

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

In this section, you will learn about the following topics:

1. How to install Oracle SnowConvert.

2. How to migrate your Oracle code.

3. How to interpret the results after migration.

First, let's suppose you have three different example statements:

• An invalid CREATE TABLE statement.

• A CREATE TABLE statement (with one syntax error).

• A CREATE VIEW statement.

And we want to migrate them using Oracle SnowConvert.

This code will be used for further sub-sections.

--Invalid Create Table
CREATE TABLE! table_invalid
(
  col1 VARCHAR2(255 BYTE),
  col2 VARCHAR2!
);

--Create Table (with an error)
CREATE TABLE table1
(
  col1 VARCHAR2(255 BYTE),
  col2 VARCHAR2!
);

--Create View (valid example)
CREATE OR REPLACE FORCE VIEW view1
AS
    SELECT 
        XMLSEQUENCE(1), 
        col1, 
        col2 
    FROM table1;