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

Hi,all!
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?
Regards!
Alan
Re: dict_columns [message #261578 is a reply to message #261515] Thu, 23 August 2007 01:30 Go to previous message
Michel Cadot
Messages: 64140
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.

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


Current Time: Fri Dec 09 07:41:03 CST 2016

Total time taken to generate the page: 0.31974 seconds