在oracle 中創建表如下：

?

    create table TM_FAULT_BUS_ATTENTION

(

  BUS_NO     NUMBER(6),

  LINE_NO    VARCHAR2(6),

  FILA_NO    NUMBER(3),

  BUS_JOB_NO VARCHAR2(20) not null,

  CITY_NO    NUMBER(4),

  GROUP_NO   NUMBER(4),

  INS_TIME   DATE,

  IS_SEND    NUMBER(1) default 1

);
  

    -- Add comments to the table 

comment on table TM_FAULT_BUS_ATTENTION

  is '添加故障車輛信息表';

-- Add comments to the columns 

comment on column TM_FAULT_BUS_ATTENTION.BUS_NO

  is '車號';

comment on column TM_FAULT_BUS_ATTENTION.LINE_NO

  is '線路號';

comment on column TM_FAULT_BUS_ATTENTION.FILA_NO

  is '公司號';

comment on column TM_FAULT_BUS_ATTENTION.BUS_JOB_NO

  is '車工號';

comment on column TM_FAULT_BUS_ATTENTION.CITY_NO

  is '地區';

comment on column TM_FAULT_BUS_ATTENTION.GROUP_NO

  is '車隊';

comment on column TM_FAULT_BUS_ATTENTION.INS_TIME

  is '下載時間';

comment on column TM_FAULT_BUS_ATTENTION.IS_SEND

  is '是否已發';
  

?

    備注加好以后，那么如何查詢呢？


  

    查詢表注釋信息如下：
  

    SELECT  TABLE_NAME,  TABLE_TYPE,  COMMENTS FROM  USER_TAB_COMMENTS WHERE  TABLE_NAME = 'TM_FAULT_BUS_ATTENTION';
  

    查詢表中字段注釋信息如下：
  

    SELECT  TABLE_NAME,  COLUMN_NAME,  COMMENTS FROM  USER_COL_COMMENTS WHERE  TABLE_NAME = 'TM_FAULT_BUS_ATTENTION';
  

    查詢表中某個字段的注釋如下：
  

    select  comments  from USER_COL_COMMENTS where table_name= 'TM_FAULT_BUS_ATTENTION' and column_name= 'LINE_NO'
  

    

    注意：表名，字段名要大寫！
  

?

?

在oracle中操作表及字段注釋