I want to get all the user defined type I have defined so far. Please tell me how to display it? And I want to know how to drop a UDT?
drop type <type name?
Is this correct?
I want to get all the user defined type I have defined so far. Please tell me how to display it? And I want to know how to drop a UDT?
drop type <type name?
Is this correct?
Query
dba_types
,all_types
, oruser_types
depending on what privileges you have and what types you are looking for.user_types
will list the types that are owned by the current user.all_types
will list all the types that the current user has access to which will include types owned by other users that the current user has been granted privileges on.dba_types
will list all the types in the database but you would need privileges to be able to query thedba_*
views such as theselect any dictionary
privilege or theselect_catalog_role
role.