Re: Field Descriptions?

There are data dictionary objects that hold comments on Oracle tables and coluumns.

Perform the following query:

select object_name, object_type
from all_objects
where object_name like '%COMMENT%';

You can store them there.

Daniel Morgan

David Wright wrote:

> I just got a hold of a oracle database but don't really know what the field
> names refer to. Is there a place where 'field name descriptions' are usually
> put? For example, Access has something called 'variable descriptions', SAS
> has something called 'variable labels'.
>
> Field names, locations and labels are usually something I call a 'data
> dictionary' -- which may be somewhat different than what Oracle calls a 'data
> dictionary'. If there is a 'common' place to put field descriptions, please
> let me know.
>
> -david
Received on Fri Apr 26 2002 - 01:30:19 CEST