RE: Thoughts on comments

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 22 Mar 2013 00:56:55 -0400
Message-ID: <007101ce26b9$add202f0$097608d0$_at_rsiz.com>



desc does not show the comments. The comments are kept in user_tab_comments and user_col_comments (also dba_ <similar> as usual).

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2330142045 43

is useful.

I personally rarely use table and column comments, and when I do it (so far) has been on tables and columns I'm creating to demonstrate or test some feature, where I want to keep the column names very short for ad hoc query typing yet want to be able to understand what is in the columns easily. Other than that I don't usually have comments in the database unless the tool being used to manage the data model automagically populates them.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rajugaru.vij_at_gmail.com
Sent: Friday, March 22, 2013 12:37 AM
To: z b
Cc: oracle-l_at_freelists.org
Subject: Re: Thoughts on comments

Noob question,
If I describe the object, will these comments be visible?

------Original Message------
From: z b
To: raju raju
Cc: oracle-l_at_freelists.org
Subject: Re: Thoughts on comments
Sent: Mar 22, 2013 10:02 AM

> Will that increase dictionary space?

Obviously.

> Will that have any performance issues?

Not sure. It's metadata, so tools like Toad and SQLDeveloper can see it. Don't think it would impact normal queries.

> How to use comments? I mean to add and retrieve. Would be helpful

The idea is the database will be "self-documenting". This is what ER Diagrams are for, not necessarily metadata adds like "comments".

On Fri, Mar 22, 2013 at 12:29 AM, <rajugaru.vij_at_gmail.com> wrote:
> Hi,
>
> Nice, I never saw any comment on any of the objects or columns in my
database.
>
> Questions:
>
> Will that increase dictionary space?
> Will that have any performance issues?
> How to use comments? I mean to add and retrieve. Would be helpful
>
> Thanks
> Sent on my BlackBerryR
>
> -----Original Message-----
> From: z b <zimsbait_at_gmail.com>
> Sender: oracle-l-bounce_at_freelists.org
> Date: Fri, 22 Mar 2013 00:25:21
> To: <oracle-l_at_freelists.org>
> Reply-To: zimsbait_at_gmail.com
> Subject: Thoughts on comments
>
> Listers,
>
> Just wanted to get a general opinion on using comments in the
> database. For example COMMENT ON COLUMN table.column "No comment".
>
> Does anyone do this as a regular best practice? I would prefer to see
> this abstraction in a data model, maybe not pushed to the database
> layer, especially since not all RDBMS engines have "comment"
> functionality.
>
> The thought is we should do this for every column, every table, every
> oracle db. This ends up being several million comments added to the
> our various instances.
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Sent on my BlackBerryR--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 22 2013 - 05:56:55 CET

Original text of this message