How to give a table, column incorporation? http:www.oradb.net

xiaoxiao2021-03-06  15

System environment:

1, Database: Oracle 8i R3 (8.1.7) for NT Enterprise Edition

Description:

SQL> Comment on Table Table IS 'Table Note';

Comments have been created.

SQL> Comment on column table. Column is 'column annotation';

Comments have been created.

SQL> SELECT * from user_tab_comments where comments is not null;

SQL> Select * from user_col_comments where comments is not null;

转载请注明原文地址:https://www.9cbs.com/read-47984.html

New Post(0)