Using a Varray Type to Define a Column
CREATE TYPE t_varray AS VARRAY(3) OF VARCHAR2(50);
/
SQL> CREATE TABLE emp(
2 id INTEGER PRIMARY KEY,
3 first_name VARCHAR2(10),
4 last_name VARCHAR2(10),
5 addresses t_varray
6 );
Table created.
SQL>
Home »
Oracle »
PL/SQL »
Oracle »
PL/SQL »
Varrays:
- Creating a Varray Type
- Using a Varray Type to Define a Column
- Getting Information on a Varray
- Populating a Varray with Elements
- Retrieving Elements from a Varray
- Using TABLE() to Treat a VArrays
- Modifying Elements of a Varray
Related: