1、--創建表create table test ( id varchar2(200) primary key not null, sort number, name varchar(200))--欄位加註釋comment on column test.id is 'id'; comment on ...
此文檔會不斷更新
1、--創建表
create table test (
id varchar2(200) primary key not null,
sort number,
name varchar(200)
)
--欄位加註釋
comment on column test.id is 'id';
comment on column test.sort is '序號';
--表加註釋
comment on table test is '測試表'
dbms_output.put_line --輸出
alter table suifangxinxi
add (fujianfuwutaidu varchar2(2));
comment on column suifangxinxi.fujianfuwutaidu is '輔檢服務態度';
alter table suifangxinxi
add (fujianfuwuzhiliang varchar2(2));
comment on column suifangxinxi.fujianfuwuzhiliang is '輔檢服務質量';
2、創建job
declare job number;
begin
dbms_job.submit(
job =>job,
what=>'PROC1;PROC2;',
next_date => sysdate,
interval =>'TRUNC(SYSDATE + 1))';--每天凌晨同步一次
commit;
end;
3、創建DB_LINK
create database link DBLINK_HYEMR
connect to usertestemr identified by "useremr_mhxfy"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = crds3db)))';
4、同一個資料庫中，可以直接通過用戶.數據表來比較
select a.dddzhi 馬山ddd值,b.dddzhi 福清ddd值, a.*
from 馬山用戶名.x_yaopin a, 福清用戶名.x_Yaopin b
where a.yaopinid = b.yaopinid
and a.dddzhi != b.dddzhi
