create type array as varray(5) of varchar(10); create type pessoa as object ( id number(2), teste array ); create table tb_pessoa of pessoa; insert into tb_pessoa values (1, arrya('5555', '444')); select * from table ( select teste from tb_pessoa); ___________________________ FUNCTION: create type aluno as object( id number(2), MAP MEMBER FUNCTION get_id RETURN NUMBER ); CREATE OR REPLACE TYPE BODY aluno AS MAP MEMBER FUNCTION get_id return number IS Begin return ID; END END; SELECT a.get_id() FROM tb_aluno a;