Create View

In this section, you could find information about Oracle Views and their Snowflake equivalent. The syntax of subquery used to create the view can be found in the SELECT section

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Some parts in the output code are omitted for clarity reasons.

Create View

IN -> Oracle_01.sql

CREATE OR REPLACE VIEW View1 AS SELECT Column1 from Schema1.Table1;

OUT -> Oracle_01.sql

CREATE OR REPLACE VIEW View1
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
AS
SELECT Column1 from
Schema1.Table1;

The following clauses for Create View are removed:

• No Force/ Force

• Edition Clause

• Sharing Clause

• Default collation

• Bequeath clause

• Container clause

IN -> Oracle_02.sql

CREATE OR REPLACE
NO FORCE
NONEDITIONABLE
VIEW Schema1.View1
SHARING = DATA
DEFAULT COLLATION Collation1
BEQUEATH CURRENT_USER
AS SELECT Column1 from Schema1.Table1
CONTAINER_MAP;

OUT -> Oracle_02.sql

CREATE OR REPLACE VIEW Schema1.View1
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
AS
SELECT Column1 from
Schema1.Table1;

Alter View

Alter is not supported by SnowConvert yet.

Drop View

The CASCADE CONSTRAINT clause is not supported yet.

IN -> Oracle_03.sql

DROP VIEW Schema1.View1;

DROP VIEW Schema1.View1
CASCADE CONSTRAINTS;

OUT -> Oracle_03.sql

DROP VIEW Schema1.View1;

DROP VIEW Schema1.View1
CASCADE CONSTRAINTS !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'DropBehavior' NODE ***/!!!;

Related EWIs

1. SSC-EWI-0073: Pending Functional Equivalence Review.