用ORacle的数据库链路: insert into table1 select * from tablename@databaselink如何创建DBLINK: CREATE PUBLIC DATABASE LINK test CONNECT TO system IDENTIFIED BY manager USING 'myoracle'(连接另一数据库的字串) 注意: GLOBAL_NAME的值设为FALSE
dblink的问题已经解决了 谢谢大家, 但是 if exists(select 字段名 from 表名) then 这个问题如何解决啊??相信大家在写过程或者函数中都遇到过这样的问题,哪位高手指点一二啊!
oracle有exists,类似 select * from table_a where exists (select col_a from table_b where table_a.col_a =table_b.cola)
insert into table1
select * from tablename@databaselink如何创建DBLINK:
CREATE PUBLIC DATABASE LINK test
CONNECT TO system IDENTIFIED BY manager USING 'myoracle'(连接另一数据库的字串)
注意:
GLOBAL_NAME的值设为FALSE