Re: Field Definitions

On 21 Mar 2005 09:11:13 -0800, "mike" <hillmw_at_charter.net> wrote:

>Is there a field where I can put what the field is used for?
>
>For example, if I have a field called site then the definition of that
>field would be: 'Location or site where the activity is conducted'.
>
>I'd then like to be able to do a query of the meta-data using something
>like:
>
>select column_name, data_type, data_length from all_tab_columns where
>table_name='mytable'
>
>and be able to get the field definition data as well.
>
>Any help is appreciated.
>
>Mike

comment on <table>.<column_name> 'Location or site where the activity is conducted'

can be retrieved using all_col_comments

--
Sybrand Bakker, Senior Oracle DBA