Path: news.easynews.com!easynews!priapus.visi.com!news-out.visi.com!hermes.visi.com!nnxp1.twtelecom.net!news-east.rr.com!cyclone.kc.rr.com!news.kc.rr.com!news-west.rr.com!cyclone1.we.ipsvc.net!cyclone3.we.ipsvc.net!typhoon1.we.ipsvc.net.POSTED!not-for-mail
From: "Alex Ivascu" <alexdivascu@yahoo.com>
Newsgroups: comp.databases.oracle.misc
References: <68326679.0204041518.64da74bd@posting.google.com>
Subject: Re: altering table and column comments from PL/SQL
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <lHar8.13662$071.2883748@typhoon1.we.ipsvc.net>
Date: Fri, 05 Apr 2002 05:34:09 GMT
NNTP-Posting-Host: 24.126.92.36
X-Complaints-To: abuse@attbi.com
X-Trace: typhoon1.we.ipsvc.net 1017984849 24.126.92.36 (Thu, 04 Apr 2002 21:34:09 PST)
NNTP-Posting-Date: Thu, 04 Apr 2002 21:34:09 PST
Organization: AT&T Broadband
Xref: easynews comp.databases.oracle.misc:79701
X-Received-Date: Thu, 04 Apr 2002 22:35:03 MST (news.easynews.com)

Here's a quick example, on how it should work:

declare
  my_comment varchar2(200);
begin
  my_comment := 'comment on table test2 is ''Testing only.''';
  execute immediate my_comment;
end;
/

select comments from all_tab_comments where table_name='TEST2';

COMMENTS
---------------
Testing only.

Hope this helps.

Alex Ivascu
DBA


"Adam Rothberg" <adamr1000@hotmail.com> wrote in message
news:68326679.0204041518.64da74bd@posting.google.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.