To insert an explanatory re on the NOTES column of the SHIPPING table, you might issue the following statement: COMMENT ON COLUMN shipping.notes
IS 'Special packing or shipping instructions';
To drop this comment from the database, issue the following statement: COMMENT ON COLUMN shipping.notes IS ' ';
USER_COL_COMMENTS
IS 'Special packing or shipping instructions';
To drop this comment from the database, issue the following statement: COMMENT ON COLUMN shipping.notes IS ' ';
USER_COL_COMMENTS
建立描述已经成功,如何查看已建好的描述呢?
15:02:10 jlanzpa817>desc USER_COL_COMMENTS
名称 空? 类型
----------------------------------------- -------- --------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
COMMENTS VARCHAR2(4000)