| |
 |
|
DBA_TAB_COMMENTS view tips
Oracle Tips by Burleson Consulting |
DBA_TAB_COMMENTS
<< Return to the index
Oracle 11g makes the following comments about the DBA_TAB_COMMENTS table: "Comments on all tables and views in the database"
Related notes on DBA_TAB_COMMENTS:
Column description of the DBA_TAB_COMMENTS view:OWNERDescription of DBA_TAB_COMMENTS.OWNER: "Owner of the object" TABLE_NAMEDescription of DBA_TAB_COMMENTS.TABLE_NAME: "Name of the object" TABLE_TYPEDescription of DBA_TAB_COMMENTS.TABLE_TYPE: "Type of the object" COMMENTSDescription of DBA_TAB_COMMENTS.COMMENTS: "Comment on the object"
DBA_TAB_COMMENTS View SourceOracle 11g's data dictionary defines the DBA_TAB_COMMENTS view using the following source query:
select u.name, o.name,
decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 'UNDEFINED'),
c.comment$
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.com$ c
where o.owner# = u.user#
and (o.type# in (4) /* view */
or
(o.type# = 2 /* tables */
AND /* excluding iot-overflow, nested or mv container tables */
not exists (select null
from sys.tab$ t
where t.obj# = o.obj#
and (bitand(t.property, 512) = 512 or
bitand(t.property, 8192) = 8192 OR
bitand(t.property, 67108864) = 67108864))))
and o.obj# = c.obj#(+)
and c.col#(+) is null
 |
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
|
|
