select sysdate from dual@HN_HMP;
獲取DBlink連接的庫(kù)的時(shí)間铭乾。
select * from phip_qa_object_base_info@DBHNHMP;
各省質(zhì)控編碼楷拳，
select * from dw_dim_area;
select * from dw_dim_county t where t.dim_area ='419900000000';
--?Create?table
create?table?PHIP_GOV_STAFF_INFO
(
id????????????????????????VARCHAR2(36)?not?null,
name??????????????????????NVARCHAR2(128)?not?null,
login_name????????????????VARCHAR2(36)?not?null,
gender_code???????????????VARCHAR2(2),
birth_time????????????????DATE,
birthplace_addr???????????NVARCHAR2(512),
id_no?????????????????????VARCHAR2(18),
technical_code????????????NVARCHAR2(128),
employer_addr?????????????NVARCHAR2(512),
employer_tel_no???????????VARCHAR2(36),
effective_time_low????????DATE,
effective_time_high???????DATE,
affiliated_org_admin_code?VARCHAR2(128),
status_code???????????????NVARCHAR2(36),
is_permanent??????????????NUMBER(1),
title_code????????????????VARCHAR2(36),
title_date????????????????DATE,
attend_work_date??????????DATE,
nation_code???????????????VARCHAR2(36),
education_level_code??????VARCHAR2(36),
create_at?????????????????DATE,
create_by?????????????????VARCHAR2(36),
modify_by?????????????????VARCHAR2(36),
modify_at?????????????????DATE,
state?????????????????????NUMBER(1)
)
tablespace?TBL_PHIP
pctfree?10
initrans?1
maxtrans?255
storage
(
initial?64
next?1
minextents?1
maxextents?unlimited
);
--?Add?comments?to?the?table
comment?on?table?PHIP_GOV_STAFF_INFO
is?'行政人員信息表';
--?Add?comments?to?the?columns
comment?on?column?PHIP_GOV_STAFF_
INFO.id
is?'ID';
comment?on?column?PHIP_GOV_STAFF_
INFO.name
is?'姓名';
comment?on?column?PHIP_GOV_STAFF_INFO.login_name
is?'登錄名稱';
comment?on?column?PHIP_GOV_STAFF_INFO.gender_code
is?'性別';
comment?on?column?PHIP_GOV_STAFF_INFO.birth_time
is?'出生日期';
comment?on?column?PHIP_GOV_STAFF_INFO.birthplace_addr
is?'出生地址';
comment?on?column?PHIP_GOV_STAFF_INFO.id_no
is?'身份證號(hào)';
comment?on?column?PHIP_GOV_STAFF_INFO.technical_code
is?'職務(wù)';
comment?on?column?PHIP_GOV_STAFF_INFO.employer_addr
is?'工作地址';
comment?on?column?PHIP_GOV_STAFF_INFO.employer_tel_no
is?'聯(lián)系電話';
comment?on?column?PHIP_GOV_STAFF_INFO.effective_time_low
is?'有效期開始';
comment?on?column?PHIP_GOV_STAFF_INFO.effective_time_high
is?'有效期結(jié)束';
comment?on?column?PHIP_GOV_STAFF_INFO.affiliated_org_admin_code
is?'所屬行政機(jī)構(gòu)編碼';
comment?on?column?PHIP_GOV_STAFF_INFO.status_code
is?'賬號(hào)狀態(tài)';
comment?on?column?PHIP_GOV_STAFF_INFO.is_permanent
is?'是否是在編人員';
comment?on?column?PHIP_GOV_STAFF_INFO.title_code
is?'職稱';
comment?on?column?PHIP_GOV_STAFF_INFO.title_date
is?'職稱取得時(shí)間';
comment?on?column?PHIP_GOV_STAFF_INFO.attend_work_date
is?'參加工作時(shí)間';
comment?on?column?PHIP_GOV_STAFF_INFO.nation_code
is?'民族';
comment?on?column?PHIP_GOV_STAFF_INFO.education_level_code
is?'教育程度';
comment?on?column?PHIP_GOV_STAFF_INFO.state
is?'狀態(tài)';
