Comment on page
Getting Started
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;