CREATE TABLE bm_print_set ( print_type VARCHAR2(2), print_size VARCHAR2(50) ) / COMMENT ON TABLE bm_print_set IS '打印机纸张类型'; COMMENT ON COLUMN bm_print_set.print_type IS '纸张类型'; COMMENT ON COLUMN bm_print_set.print_size IS '纸张名称';
当然可以拉,看看这张表吧 create table HMCW.TCadreInScene ( LID NUMBER(18) not null, DCSJ DATE, LCSJ DATE, NAME VARCHAR2(50), Duty VARCHAR2(10), Depart VARCHAR2(10), CHKCLASS VARCHAR2(50), WORKPLAN VARCHAR2(500), WORKDESCRIPTION VARCHAR2(500), Problem VARCHAR2(500), Result VARCHAR2(500), ProcessRQ VARCHAR2(500), Re VARCHAR2(500), DTN VARCHAR2(50) ) / comment on column HMCW.TCadreInScene.LID is '序号' / comment on column HMCW.TCadreInScene.DCSJ is '到场时间' / comment on column HMCW.TCadreInScene.LCSJ is '离场时间' / comment on column HMCW.TCadreInScene.NAME is '姓名' / comment on column HMCW.TCadreInScene.Duty is '职务' / comment on column HMCW.TCadreInScene.Depart is '部门' / comment on column HMCW.TCadreInScene.CHKCLASS is '检查类别' / comment on column HMCW.TCadreInScene.WORKPLAN is '工作计划' / comment on column HMCW.TCadreInScene.WORKDESCRIPTION is '工作写实' / comment on column HMCW.TCadreInScene.Problem is '发现问题' / comment on column HMCW.TCadreInScene.Result is '处理结果' / comment on column HMCW.TCadreInScene.ProcessRQ is '整改要求' / comment on column HMCW.TCadreInScene.Re is '备注' / comment on column HMCW.TCadreInScene.DTN is '定性' /
create table contact ( CONTACTID VARCHAR2(16) not null, NAME VARCHAR2(20) ) comment on column contact.contactid is '客户编号'; comment on column contact.name is '客户名称';
(
print_type VARCHAR2(2),
print_size VARCHAR2(50)
)
/
COMMENT ON TABLE bm_print_set IS '打印机纸张类型';
COMMENT ON COLUMN bm_print_set.print_type IS '纸张类型';
COMMENT ON COLUMN bm_print_set.print_size IS '纸张名称';
create table HMCW.TCadreInScene (
LID NUMBER(18) not null,
DCSJ DATE,
LCSJ DATE,
NAME VARCHAR2(50),
Duty VARCHAR2(10),
Depart VARCHAR2(10),
CHKCLASS VARCHAR2(50),
WORKPLAN VARCHAR2(500),
WORKDESCRIPTION VARCHAR2(500),
Problem VARCHAR2(500),
Result VARCHAR2(500),
ProcessRQ VARCHAR2(500),
Re VARCHAR2(500),
DTN VARCHAR2(50)
)
/
comment on column HMCW.TCadreInScene.LID is
'序号'
/
comment on column HMCW.TCadreInScene.DCSJ is
'到场时间'
/
comment on column HMCW.TCadreInScene.LCSJ is
'离场时间'
/
comment on column HMCW.TCadreInScene.NAME is
'姓名'
/
comment on column HMCW.TCadreInScene.Duty is
'职务'
/
comment on column HMCW.TCadreInScene.Depart is
'部门'
/
comment on column HMCW.TCadreInScene.CHKCLASS is
'检查类别'
/
comment on column HMCW.TCadreInScene.WORKPLAN is
'工作计划'
/
comment on column HMCW.TCadreInScene.WORKDESCRIPTION is
'工作写实'
/
comment on column HMCW.TCadreInScene.Problem is
'发现问题'
/
comment on column HMCW.TCadreInScene.Result is
'处理结果'
/
comment on column HMCW.TCadreInScene.ProcessRQ is
'整改要求'
/
comment on column HMCW.TCadreInScene.Re is
'备注'
/
comment on column HMCW.TCadreInScene.DTN is
'定性'
/
这个注释在powerbuilder里面可以看到么?
能不能达到:SELECT column1 as comment1的效果呀?
这些注释存在oracle的什么地方(哪个表or哪个视图?)怎么才能看到?
SQL> desc dba_col_comments;
名称 是否为空?类型
------------------------------- -------- ----
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
COMMENTS VARCHAR2(4000)
如果在程序界面上需要显示,最好还是另建一张表
专门存储注释。
如果只是方便以后使用的程序员参考查找,还是
作成脚本,在每个字段后加注释。
脚本片段:
...
ID VARCHAR2(10), --序列号
...
(
CONTACTID VARCHAR2(16) not null,
NAME VARCHAR2(20)
)
comment on column contact.contactid
is '客户编号';
comment on column contact.name
is '客户名称';