RE: Db_block_size

From: Vidya Kalyanaraman <kvidya13_at_hotmail.com>
Date: Thu, 08 Jun 2000 14:59:51 EDT
Message-Id: <10522.108275@fatcity.com>

Hi Umesh...
SQL> create table x(y varchar2(20));

Table created.

SQL> comment on table x is 'it is test';

Comment created.

SQL> comment on column x.y is 'it is a test column';

Comment created.

SQL> select * from all_tab_comments where   2 table_name='X';

OWNER                          TABLE_NAME                     TABLE_TYPE


------------------------------ ------------------------------ -----------

COMMENTS

---

LOGOS                          X                              TABLE

it is test

SQL> select * from all_col_comments where

   column_name='Y' and table_name='X'
SQL>

OWNER                          TABLE_NAME


------------------------------ ------------------------------

COLUMN_NAME

---

COMMENTS

---

LOGOS                          X

Y
it is a test column

Hope it helps

Thanks
Vidya

From: "Gopal , Umesh" <ugopal_at_proxicom.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: Db_block_size
Date: Thu, 08 Jun 2000 09:58:57 -0800

Can anyone please tell me how to add and view comments to a table ??

Thanks
Umesh

--
Author: Gopal , Umesh
   INET: ugopal_at_proxicom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

________________________________________________________________________

Received on Thu Jun 08 2000 - 13:59:51 CDT