Creating a Table of a Type which contains a nested table
From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 8 Feb 2009 17:21:59 -0500
Message-ID: <fUIjl.3916$PE4.3547_at_nlpi061.nbdc.sbc.com>
Oracle 10.2.0.3
Windows Server 2003
Date: Sun, 8 Feb 2009 17:21:59 -0500
Message-ID: <fUIjl.3916$PE4.3547_at_nlpi061.nbdc.sbc.com>
Oracle 10.2.0.3
Windows Server 2003
Example 1 with VARRAY:
CREATE OR REPLACE TYPE t_test AS OBJECT
(
field1 VARCHAR2(10),
array1 t_array_va,
array2 t_array_va
);
CREATE OR REPLACE TYPE t_test_tab AS TABLE OF t_test; /
Example 2 with NESTED TABLES:
CREATE OR REPLACE TYPE t_test AS OBJECT
(
field1 VARCHAR2(10),
array1 t_array_nt,
array2 t_array_nt
);
CREATE OR REPLACE TYPE t_test_tab AS TABLE OF t_test; /
I've seen example 1 syntax in Oracle documentation but not for example 2. Is the syntax for example 2 correct? Received on Sun Feb 08 2009 - 16:21:59 CST