December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP TYPE
CREATE Incomplete Syntax:
CREATE [OR REPLACE] TYPE [schema.]type_name
CREATE Object Syntax:
CREATE [OR REPLACE] TYPE [schema.]type_name[AUTHID {CURRENT_USER | DEFINER}] {IS | AS} OBJECT (attribute datatype[,attribute datatype...]), {MEMBER | STATIC} {procedure_spec|function_spec} [,PRAGMA RESTRICT_REFERENCES ({method_name| DEFAULT}, {RNDS|WNDS | RNPS | WNPS | TRUST} [,{RNDS | WNDS | RNPS | WNPS | TRUST}...] [,PRAGMA...] {MEMBER | STATIC} {procedure_spec|function_spec} [,PRAGMA RESTRICT_REFERENCES ({method_name| DEFAULT}, {RNDS | WNDS | RNPS | WNPS | TRUST} [,{RNDS | WNDS | RNPS | WNPS | TRUST}...] [,PRAGMA...] ...] [, {MAP | ORDER} MEMBERfunction_spec]
Create VARRAY Syntax:
CREATE [OR REPLACE] TYPE [schema.]type_name{IS | AS} {VARRAY | VARYING ARRAY} (limit) OFdatatype
CREATE Nested Table Syntax:
CREATE [OR REPLACE] TYPE [schema.]type_name{IS | AS} TABLE OFdatatype
ALTER Syntax:
ALTER TYPE [schema.]type_name{ COMPILE [DEBUG] [SPECIFICATION | BODY] [REUSE SETTINGS] | REPLACE [AUTHID {CURRENT_USER | DEFINER}] AS OBJECT (attributedatatype[,attributedatatype...]), {MEMBER | STATIC} {procedure_spec|function_spec} [,PRAGMA RESTRICT_REFERENCES ({method_name| DEFAULT}, {RNDS | WNDS | RNPS | WNPS | TRUST}] [,{RNDS | WNDS | RNPS | WNPS | TRUST}...]),PRAGMA...] {MEMBER | STATIC} {procedure_spec|function_spec} [,PRAGMA RESTRICT_REFERENCES ({method_name| DEFAULT}, {RNDS | WNDS | RNPS | WNPS | TRUST} [,{RNDS | WNDS | RNPS | WNPS | TRUST}...)[,PRAGMA...] ...