Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create or replace type LineItemT as object (
    ItemId varchar (50),
    Quantity int,
    Description varchar (50) ,
    UnitPrice decimal (10,5) ,
    LineTotal decimal (10,5)
    )
/    
create or replace type LineItemsT as table of LineItemT;
create table Invoice (
    Invoice# varchar (50) not null,
    shipdate date,
    terms VARCHAR(50),
    LineItems LineItemsT 
)
nested table LineItems store as LineItems
/
insert into Invoice values (
    'INV001', date'27-04-18', 'CREDIT', 
    LineItemsT (LineItemT ('A000100', 1, 'GREEN WIDGET', 35.10, 35.10),
                LineItemT ('A000200', 6, 'BLUE WIDGET',  35.10, 210.60)));
1 rows affected

select Invoice# invNo, li.* 
from invoice i, table (i.lineitems) li;


INVNO
ITEMID
QUANTITY
DESCRIPTION
UNITPRICE
LINETOTAL


INV001
A000100
1
GREEN WIDGET
35.1
35.1

INV001
A000200
6
BLUE WIDGET
35.1
210.6

INVNO	ITEMID	QUANTITY	DESCRIPTION	UNITPRICE	LINETOTAL
INV001	A000100	1	GREEN WIDGET	35.1	35.1
INV001	A000200	6	BLUE WIDGET	35.1	210.6