sql - Accessing oracle type attributes from system tables -


is possible access oracle type attribute information of system tables? example given type:

create or replace  type custom_type object (   id number,   name varchar2,   ...     ) 

i able access information of form

type_name,attribute_name,positon,data_type custom_type,id,1,number custom_type,name,2,varchar2 

this sort of functionality available function , procedure arguments in user_arguments table, have been unable find similar type attributes.

any appreciated.

thanks,

matt.

this query list type objects owned current user.

select * user_types; 

check this link available system tables , brief on contained information.


Comments

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

Error while updating a record in APEX screen -

c++ - In an add-in in Excel, written in C(++), how does one get the name of the function which called into the addin? -