View Conversion Rules

View Conversion Rules

RULE-11001

Type

REMOVED

Description

'WITH CHECK OPTION' has been removed.

Original SQL Text

CREATE OR REPLACE VIEW v1
AS SELECT * FROM t1
WITH CHECK OPTION;

Processed SQL Text

CREATE OR REPLACE VIEW v1 
AS SELECT * FROM t1
/* WITH CHECK OPTION */ /* [REMOVED] RULE-11001 : 'WITH CHECK OPTION' is removed */;

RULE-11002

Type

REMOVED

Description

The alias constraints have been removed.

Original SQL Text

CREATE OR REPLACE VIEW v1
(a1 UNIQUE)
AS SELECT c1 FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1
(a1 /* UNIQUE */ /* [REMOVED] RULE-11002 : Inline constraints are removed */)
AS SELECT c1 FROM t1;

RULE-11003

Type

TODO

Description

View level constraints must be converted manually.

Original SQL Text

CREATE OR REPLACE VIEW v1
(c1, CONSTRAINT v1_uk UNIQUE(c1))
AS SELECT c1 FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1 
(c1, CONSTRAINT v1_uk UNIQUE(c1) /* [TODO] RULE-11003 : Out of line constraint must be converted manually */)
AS SELECT c1 FROM t1;

RULE-11004

Type

REMOVED

Description

BEQUEATH clause has been removed.

Original SQL Text

CREATE OR REPLACE VIEW v1 
BEQUEATH CURRENT_USER 
AS SELECT * FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1 
/* BEQUEATH CURRENT_USER */ /* [REMOVED] RULE-11004 : BEQUEATH clause is removed */
AS SELECT * FROM t1;

RULE-11005

Type

TODO

Description

XMLType view clause should be converted manually.

Original SQL Text

CREATE OR REPLACE VIEW v1
OF XMLTYPE WITH OBJECT ID DEFAULT
AS SELECT * FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1 
OF XMLTYPE WITH OBJECT ID DEFAULT /* [TODO] RULE-11005 : XMLType view should be manually converted */ 
AS SELECT * FROM t1;

RULE-11006

Type

TODO

Description

The clause of object type view should be manually converted.

Original SQL Text

CREATE OR REPLACE VIEW v1_1
OF type1 UNDER v1
AS SELECT * FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1_1
OF type1 UNDER v1 /* [TODO] RULE-11006 : An object view must be converted manually */
AS SELECT * FROM t1;

RULE-11007

Type

REMOVED

Description

VISIBLE or INVISIBLE has been removed.

Original SQL Text

CREATE OR REPLACE VIEW v1
(c1, c2 INVISIBLE)
AS SELECT * FROM t1;

Processed SQL Text

CREATE OR REPLACE VIEW v1
(c1, c2 /* INVISIBLE */ /* [REMOVED] RULE-11007 : VISIBLE or INVISIBLE is removed */)
AS SELECT * FROM t1;

RULE-11008

Type

REMOVED

Description

FORCE has been removed.

Original SQL Text

CREATE OR REPLACE FORCE VIEW v1
(c1, c2)
AS SELECT * FROM t1;

Processed SQL Text

CREATE OR REPLACE /* FORCE */ /* [REMOVED] RULE-11008 : FORCE has been removed */ VIEW v1
(c1, c2)
AS SELECT * FROM t1;