Home » RDBMS Server » Server Administration » dict_columns
dict_columns [message #261515] Wed, 22 August 2007 22:17 Go to next message
Messages: 115
Registered: July 2007
Senior Member

When I query on DICT_COLUMNS,I noticed some table have columns commented,some null,for example:
  select clumn_name,comments from dict_columns where table_name='USER_TABLES' 

it returned comments.
but on table_name='V$DATAFILE',there is no comments.
Could someone help me?
Re: dict_columns [message #261578 is a reply to message #261515] Thu, 23 August 2007 01:30 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because some Oracle developers give comments on the tables they work and others don't.

In addition, generally speaking, there is no comment on v$ views. It seems to be an Oracle choice.

Previous Topic: Cannot able to connect my Database
Next Topic: cluster index and non-cluster index
Goto Forum:

Current Time: Thu Jul 27 09:59:35 CDT 2017

Total time taken to generate the page: 0.19449 seconds