Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: adamr1000@hotmail.com (Adam Rothberg)
Newsgroups: comp.databases.oracle.misc
Subject: altering table and column comments from PL/SQL
Date: 4 Apr 2002 15:18:40 -0800
Organization: http://groups.google.com/
Lines: 7
Message-ID: <68326679.0204041518.64da74bd@posting.google.com>
NNTP-Posting-Host: 12.34.102.140
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1017962320 15878 127.0.0.1 (4 Apr 2002 23:18:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2002 23:18:40 GMT
Xref: easynews comp.databases.oracle.misc:79689
X-Received-Date: Thu, 04 Apr 2002 16:16:25 MST (news.easynews.com)

Does anyone know how to set the COMMENT on tables and columns from a
PL/SQL procedure?  I tried contructing the necessary command string
and using EXECUTE IMMEDIATE but it did not work.

I'm using Oracle 8.1.6

Thanks.