If we create an object type or recrod type like below
create type t_data as object(
execId varchar2(500),
description varchar2(500)
);
/
then how to get the list of columns for this type at later point?. In case of tables we could use all_tab_columns
to get similar list.
You can use user_type_attrs:
SELECT *
FROM user_type_attrs
WHERE TYPE_NAME = 'T_DATA';
Column ATTR_NAME is what you are looking for.