Name

CREATE/ALTER/DROP TYPE

Synopsis

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} MEMBER function_spec]

Create VARRAY Syntax:

CREATE [OR REPLACE] TYPE [schema.]type_name
{IS | AS} {VARRAY | VARYING ARRAY} (limit) OF datatype

CREATE Nested Table Syntax:

CREATE [OR REPLACE] TYPE [schema.]type_name
{IS | AS} TABLE OF datatype

ALTER Syntax:

ALTER TYPE [schema.]type_name 
{ COMPILE [DEBUG] [SPECIFICATION | BODY] [REUSE SETTINGS]
| REPLACE [AUTHID {CURRENT_USER | DEFINER}]
  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...] ...

Get Oracle in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.