Re: altering table and column comments from PL/SQL

From: Alex Ivascu <alexdivascu_at_yahoo.com>
Date: Fri, 05 Apr 2002 05:34:09 GMT
Message-ID: <lHar8.13662$071.2883748@typhoon1.we.ipsvc.net>

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_at_hotmail.com> wrote in message news:68326679.0204041518.64da74bd_at_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.
Received on Thu Apr 04 2002 - 23:34:09 CST