<div>
select owner, view_name<br />
from dba_views<br />
where view_name like 'V%';<br />
You will notice that they mostly start with v_$. &nbsp;The v$ are synonyms.<br />
<br />
HTH<br />
Stephen<br />
<br />

</div>


select owner, view_name
from dba_views
where view_name like 'V%';
You will notice that they mostly start with v_$.  The v$ are synonyms.

HTH
Stephen



<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I'm trying to learn more Oracle my investigating the information found in the &quot;DBA&quot; views and &quot;V$&quot; views. &nbsp;Using &quot;DBA_COL_COMMENTS&quot; view I can get the table_name, the column name, and a comment about the column -- for &quot;DBA&quot; views. &nbsp;Is there any way I can obtain this information for &quot;V$&quot; views?<br />
<br />
Thanks for your help/time.<br />

</div>
</div>


Hello Experts,

I'm trying to learn more Oracle my investigating the information found in the "DBA" views and "V$" views.  Using "DBA_COL_COMMENTS" view I can get the table_name, the column name, and a comment about the column -- for "DBA" views.  Is there any way I can obtain this information for "V$" views?

Thanks for your help/time.


Oracle 9i: Is there any way to list the v$ views and all columns.

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.