– Drop existing database link
drop database link MEISHAN_2017;
– Create database link
create database link MEISHAN_2017
connect to YBSH_BASE
using '192.168.2.123:1521/orcl';
select owner,object_name
from dba_objects
where object_type='DATABASE LINK';
MERGE INTO語法:
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATCHED THEN [here you can execute some update sql or something else ]
WHEN NOT MATCHED THEN [execute something else here ! ]
例:
MERGE INTO ABSCOND T1
USING (SELECT * FROM ABSCOND@ACS7T) T2
on (T1.FLDCOND_CODE = T2.FLDCOND_CODE)
--WHEN MATCHED THEN UPDATE SET T1.NAME=T2.NAME
WHEN NOT MATCHED THEN INSERT VALUES (T2.FLDCOND_CODE,T2.FLDCOND_NAME,T2.TARGET_COLUMN);