CREATE OR REPLACE TYPE animal AS object(
  cod NUMBER,
  nome varchar2(10)
) NOT FINAL;
/

CREATE OR REPLACE TYPE macaco AS TABLE OF animal;
/
CREATE TABLE zoologico(
  cod NUMBER,
  nome varchar2(10),
  caco macaco)
NESTED TABLE caco STORE AS tabela_macaco;

INSERT INTO zoologico VALUES (2, 'DUDULANDIA', macaco(animal(123,'martinna'), animal(1234, 'albert')));

SELECT Z.cod, Z.nome FROM THE(SELECT Z.caco FROM zoologico Z WHERE Z.cod = 2) Z;