--建表
CREATE TABLE PRODUCT
(
APPLE NUMBER,
ORINGE NUMBER,
PRO_DAY DATE
);--表和列的注释
COMMENT ON TABLE PRODUCT IS '产品列表';
COMMENT ON COLUMN PRODUCT.APPLE IS '苹果数量';
COMMENT ON COLUMN PRODUCT.ORINGE IS '橘子数量';
COMMENT ON COLUMN PRODUCT.PRO_DAY IS '日期';
SELECT * FROM USER_COL_COMMENTS WHERE TABLE_NAME ='PRODUCT';
SELECT * FROM USER_TAB_COMMENTS WHERE TABLE_NAME ='PRODUCT';
当前用户SHOW USER; 获取当前用户能访问的数据字典SELECT * FROM DICTIONARY; 查询用户创建的表SELECT * FROM USER_TABLES; 数据字典的命名规则常用的数据字典用户创建的数据库对象SELECT * FROM USER_OBJECTS;用户能访问的数据库对象SELECT * FROM ALL_OBJECTS;查询列注释--建表CREATE TABLE PRODUCT(APP.