Populating a Nested Table with Elements
CREATE TYPE t_address AS OBJECT (
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5)
);
/
CREATE TYPE t_nested_table AS TABLE OF t_address;
/
CREATE TABLE emp (
id INTEGER PRIMARY KEY,
first_name VARCHAR2(10),
last_name VARCHAR2(10),
addresses t_nested_table_address
)
INSERT INTO emp VALUES (1, 'Jason', 'Bond',t_nested_table(
t_address('Main Street', 'Small town', 'CA', '12345'),
t_address('Second Street','Middle Town','CA', '54321')
)
);
Home »
Oracle »
PL/SQL »
Oracle »
PL/SQL »
Nested Table:
- Creating a Nested Table Type
- Using a Nested Table Type to Define a Column
- Get Information on Nested Table
- Populating a Nested Table with Elements
- Retrieving Elements from a Nested Table
- Using TABLE() with a Nested Table
Related: