Multiple nested tables in Oracle

Question

Is it possible to create a table with multiple nested tables, such as this example?

create or replace type t_products is object(
    name varchar(20),
    price float(4,2),
    drinks col_drinks,
    foods col_foods
);
/

create table products of t_products nested table drinks, foods store as drink, food;

Alex Poole · Accepted Answer · 2021-05-26 15:31:06Z

1

You can, but you need separate nested table .. store as ... clauses for them:

create table products of t_products
    nested table drinks store as drink,
    nested table foods store as food;

Also float can't have a scale, but you can use number anyway; and varchar should be varchar2.

db<>fiddle

answered May 26, 2021 at 15:31

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

noobieCoder Over a year ago

Thank you! It was very useful.

Collectives™ on Stack Overflow

Multiple nested tables in Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related