VARRAY Clause

Store as Varray

Syntax:

   VARRAY varray [ELEMENT] IS OF [TYPE]] (ONLY type)

   VARRAY varray [NOT] SUBSTITUTABLE AT ALL LEVELS

   VARRAY varray STORE AS LOB LOB_segname (LOB_Parameters)

   VARRAY varray STORE AS LOB LOB_segname 

   VARRAY varray STORE AS LOB (LOB_Parameters)

LOB_Parameters:

   TABLESPACE tablespace
   {ENABLE|DISABLE} STORAGE IN ROW
   STORAGE storage_clause
   CHUNK int
   PCTVERSION int
   CACHE
   CACHE READS [[NO]LOGGING]
   NOCACHE [[NO]LOGGING]
   RETENTION
   FREEPOOLS int

Related Commands:

MVIEW - CREATE MATERIALIZED VIEW
TABLE - CREATE TABLE
TABLE - ALTER TABLE

Related Views:

DBA_VARRAYS    ALL_VARRAYS     USER_VARRAYS


© Copyright SS64.com 1999-2014
Some rights reserved