Links
Comment on page

Getting Started

In this section, you will learn about the following topics:
  1. 1.
    How to install Oracle SnowConvert.
  2. 2.
    How to migrate your Oracle code.
  3. 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;