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

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -