本文共 762 字,大约阅读时间需要 2 分钟。
??????????SQL????
?????????????????SQL?????????????
?????????
???????
?? tbl_person ?????SQL???? tbl_person ????select party_id,realname from tbl_person;
?? t_customer@JTKHJFDB ?????SQL???? t_customer ????select * from t_customer@JTKHJFDB;
?? t_customer@JTKHJFDB ?????????SQL???? t_customer ?????delete from t_customer@JTKHJFDB;
??????????????ID???create synonym remote_seq for PK_SEQ@JTKHJFDB;
???????????????insert into t_customer@JTKHJFDB(ID, uuid,name)select remote_seq.nextval, to_char(party_id),realnamefrom tbl_person;
???????????????Drop DATABASE LINK JTKHJFDB;
??????????????????????
转载地址:http://appfk.baihongyu.com/