| dict_columns [message #261515] |
Wed, 22 August 2007 22:17  |
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  |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
