 |
|
DBA_COL_COMMENTS view tips
Oracle Tips by Burleson Consulting |
DBA_COL_COMMENTS
<< Return to the index
Oracle 11g makes the following comments about the DBA_COL_COMMENTS table: "Comments on columns of all tables and views"
Related notes on DBA_COL_COMMENTS:
Column description of the DBA_COL_COMMENTS view:OWNERDescription of DBA_COL_COMMENTS.OWNER: "Name of the owner of the object" TABLE_NAMEDescription of DBA_COL_COMMENTS.TABLE_NAME: "Name of the object" COLUMN_NAMEDescription of DBA_COL_COMMENTS.COLUMN_NAME: "Name of the column" COMMENTSDescription of DBA_COL_COMMENTS.COMMENTS: "Comment on the object"
DBA_COL_COMMENTS View SourceOracle 11g's data dictionary defines the DBA_COL_COMMENTS view using the following source query:
select u.name, o.name, c.name, co.comment$
from sys."_CURRENT_EDITION_OBJ" o, sys.col$ c, sys.user$ u, sys.com$ co
where o.owner# = u.user#
and o.type# in (2, 4)
and o.obj# = c.obj#
and c.obj# = co.obj#(+)
and c.intcol# = co.col#(+)
and bitand(c.property, 32) = 0 /* not hidden column */
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
