Oracle基本操作笔试面试题之dblink操作
时间:2019-01-05 23:47 来源:未知 作者:IT
1、dblink创建
create [public] database link dblink_name connect to username identified by
password using ‘connectstring’
例如：create public database link db_file_name1 connect to oracle identified by oracle_123 using CC
2、dblink操作
select * from dba_objects_name1@db_file_name1
update table table_name@db_file_name1 set 字段=、、、
3、dblink删除
drop [public] database link dblink_name
(责任编辑：IT)
1、dblink创建 create [public] database link dblink_name connect to username identified by password using ‘connectstring’
例如：create public database link db_file_name1 connect to oracle identified by oracle_123 using CC
2、dblink操作 select * from dba_objects_name1@db_file_name1
update table table_name@db_file_name1 set 字段=、、、
3、dblink删除
drop [public] database link dblink_name (责任编辑：IT) |