marrowyung
asked on
how to find any Oracle function has has UDT ?
hi,
how to find any Oracle function has has UDT ?
how to find any Oracle function has has UDT ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
marrowyung, you're kinda messing around! This question seems alsoc to be dealt with here:
https://www.experts-exchange.com/questions/29142557/is-there-any-queries-that-show-how-many-Oracle-views-objects-has-referring-Oracle-system-table-and-Synonyms.html?headerLink=workspace_participated_questions
https://www.experts-exchange.com/questions/29142557/is-there-any-queries-that-show-how-many-Oracle-views-objects-has-referring-Oracle-system-table-and-Synonyms.html?headerLink=workspace_participated_questions
ASKER
hi man,
I am sorry that, that link is about view, but what I am asking is function has UDT, right?
I am sorry that, that link is about view, but what I am asking is function has UDT, right?
> marrowyung, you're kinda messing around!
what else is new ?
what else is new ?
ASKER
this one is only function has UDT inside.
but in the other thread, once johnsoon said:
I don't see any update on this.
but in the other thread, once johnsoon said:
Now, if the view selects from a function and the function uses dynamic SQL to access ALL_TAB_COLUMNS, then all bets are off, I don't think you could ever find that reference.
I don't see any update on this.
ASKER
what i think is correct is , Geert G, the first querty you gave here most likely correct as in our test platform it works fine .
1
1
ASKER
Geert,
give you mark on this first and query from you seem works.
might need come back for this later.
give you mark on this first and query from you seem works.
might need come back for this later.
ASKER
hi,
will this works:
so this one only show function with UDT ?
which condition is for UDT only ?
will this works:
select distinct a.owner,
a.object_name,
a.object_type
from dba_objects a
join dba_types c
on (c.type_name = a.object_type)
where c.predefined = 'NO'
and c.type_name = 'FUNCTION' and a.owner ='<schema>'
order by a.owner,
a.object_name,
a.object_type;
so this one only show function with UDT ?
which condition is for UDT only ?
ASKER
"
this is what i want: user define type.