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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial