RE: Db_block_size

From: Vidya Kalyanaraman <kvidya13_at_hotmail.com>
Date: Thu, 08 Jun 2000 14:59:51 EDT
Message-Id: <10522.108274@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


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

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