Re: Thoughts on comments
- From: rajugaru.vij@xxxxxxxxx
- To: zimsbait@xxxxxxxxx,oracle-l@xxxxxxxxxxxxx
- Date: Fri, 22 Mar 2013 04:29:52 +0000
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 BlackBerry®
-----Original Message-----
From: z b <zimsbait@xxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Fri, 22 Mar 2013 00:25:21
To: <oracle-l@xxxxxxxxxxxxx>
Reply-To: zimsbait@xxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
