赞
踩
前提预警:本机必须装有Oracle客户端
130 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.130)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
select * from openquery(SQL_ORACLE,'select sysdate from dual')
【在引号中写需要查询的Oracle数据语句,引号中的语句为Oracle格式的sql语句】
【SQL_ORACLE为步骤3.2中配置的链接服务器名称】
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。