dblink
来源:互联网 发布:机械工业信息及网络 编辑:程序博客网 时间:2024/06/07 16:47
create database link link名称 connect to 对方数据库用户名 identified by 对方数据库用户密码 using '对方数据库ip:端口/实例名';
create database link auth connect to zwww_auth identified by zwww_auth using '//10.10.44.2:1521/orcl';
SELECT *
from zwww_auth(数据库名).t_role_user t
或者
SELECT *
from zwww_auth(数据库名).t_role_user@auth t
/*select *
from ZHOUSHAN_20130620.bjxlb(用户名)@slt(dblink名) b
where b.bjlbbh = 60 and b.bjxlbh not in (select lxbm from t_soc_rcsjlx)*/
对于在代码上操纵垮库的,是可以的,但是封装太死不行的话可以用视图,这时只有用视图,在数据库上可以用普通方式
create or replace view v_syslog as
select "ID","TYPE","USER_ID","USER_NAME" as USERNAME,"LOG_DATE" as LOGDATE,"OPERATE","MESSAGE","IP","MAC","STATUS" from zwww_auth.t_syslog@auth;
create database link auth connect to zwww_auth identified by zwww_auth using '//10.10.44.2:1521/orcl';
SELECT *
from zwww_auth(数据库名).t_role_user t
或者
SELECT *
from zwww_auth(数据库名).t_role_user@auth t
/*select *
from ZHOUSHAN_20130620.bjxlb(用户名)@slt(dblink名) b
where b.bjlbbh = 60 and b.bjxlbh not in (select lxbm from t_soc_rcsjlx)*/
对于在代码上操纵垮库的,是可以的,但是封装太死不行的话可以用视图,这时只有用视图,在数据库上可以用普通方式
create or replace view v_syslog as
select "ID","TYPE","USER_ID","USER_NAME" as USERNAME,"LOG_DATE" as LOGDATE,"OPERATE","MESSAGE","IP","MAC","STATUS" from zwww_auth.t_syslog@auth;
0 0
- DBLINK
- Dblink
- dblink
- dblink
- DBLINK
- DBLink
- dblink
- dblink
- dblink
- DBLINK
- dblink
- DBlink
- DBLINK
- DBLink
- dblink
- dblink
- dblink
- dblink
- Excel Vba集锦一
- web-inf目录结构
- DateTime类型在后台怎么判断是否为空
- 深度学习——白化
- 【转】C#.NET使用AnimateWindow制作淡入淡出特殊效果的窗体
- dblink
- 【转】C#检测目标机器上是否安装Microsoft .NETFramework平台
- synchronized和lock的实现原理
- 【原创】在Release与Debug两种模式下访问文件的相对路径区别
- 登陆登出
- C++之tellg和seekg
- LeetCode : Word Pattern
- 创建视图
- 盛大之行——不只是惊艳