It is possible select all user defined types in oracle from view sys.all\_types. Also it is possible to select all type attributes from sys.all\_type\_attrs.

Still, I can't find a way to select or find relationship between table types and specific object types.

For example, `CREATE OR REPLACE TYPE "VARCHAR2_TT" AS TABLE OF VARCHAR2(2000)` is defined table type. How can I use select to find out type of `VARCHAR2_TT`?

I do need it to generate procedures to print table types as varchar2.