Senior Database Architecture 

marrowyung

<div>
&quot;it is User-defined type, in computer science that is generally synonymous with &quot;record&quot;, &quot;structure&quot;, &quot;composite type&quot; or &quot;class&quot;<br />
&quot;<br />
<br />
this is what i want: user define type.
</div>


<div>
marrowyung, you're kinda messing around! This question seems alsoc to be dealt with here:<br />
<a href="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" rel="ugc">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</a>
</div>


<div>
hi man, <br />
<br />
I am sorry that, that link is about view, but what I am asking is function has UDT, right?
</div>


<div>
&gt; marrowyung, you're kinda messing around!<br />
what else is new ?
</div>


<div>
this one is only function has UDT inside.<br />
<br />
but in the other thread, once johnsoon said:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42843620-1"><span> 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.</span>
</code></pre>
<br />
I don't see any update on this.
</div>


<div>
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 .<br />
1
</div>


<div>
Geert, <br />
<br />
give you mark on this first and query from you seem works.<br />
<br />
might need come back for this later.
</div>


<div>
hi,<br />
<br />
will this works:<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42844394-1"><span>select distinct a.owner,</span>
<span>                a.object_name,</span>
<span>                a.object_type</span>
<span>  from dba_objects a</span>
<span>  join dba_types c</span>
<span>    on (c.type_name = a.object_type)</span>
<span> where c.predefined = 'NO'</span>
<span>   and c.type_name = 'FUNCTION' and a.owner ='&lt;schema&gt;'</span>
<span> order by a.owner,</span>
<span>          a.object_name,</span>
<span>          a.object_type;</span>
<span>          </span>
</code></pre>
<br />
so this one only show function with UDT ?<br />
<br />
which condition is for UDT only ?
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
how to find any Oracle function has has UDT ?
</div>
</div>


hi,

how to find any Oracle function has has UDT ?

how to find any Oracle function has has UDT ?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.