oracle show用select,Oracle Object : How to show all the fields in select query?

I don't use SQL Developer, but according to this article Showing TYPE’d Column Values in SQL Developer you could use option:

Preferences / Database / Advanced / Display Struct Value in Grid

Also you can query user_type_attr (or all_type_attr) to obtain column names. Then copy/paste select part from output and run it or create view as proposed by @sep. Here is my test data and code block:

insert into mytable values (person_typ(1, 'Paulina', 'Thomson'), date '2017-12-17');

insert into mytable values (person_typ(7, 'Keanu', 'Stevens'), date '2017-12-28');

declare

v_sql varchar2(32000);

begin

select listagg('T.CONTACT.'||attr_name||' '||attr_name, ', ')

within group (order by attr_no)

into v_sql

from user_type_attrs

where type_name = 'PERSON_TYP';

v_sql := 'SELECT '||v_sql||' FROM MYTABLE T';

dbms_output.put_line(v_sql);

execute immediate 'CREATE OR REPLACE VIEW VW_CONTACTS AS '||v_sql;

end;

select * from vw_contacts;

Result:

ID FIRST_NAME LAST_NAME

------ -------------------- -------------------------

1 Paulina Thomson

7 Keanu Stevens