卖水果的

 环境 : Windows 2003 Server + Oracle 9.2.0.7.0 

　　select * from OpenDataSource('SQLOLEDB','Data Source=SQL服务名;User ID=用户;Password=密码').数据库.dbo.表　　select * from OpenRowSet('MSDASQL','DRIVER={SQL Server}'Server=SQL服务器;UID=用户;PWD=密码',数据库.dbo.表) As myt

SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 2月 15 22:24:00 2010 

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 


连接到: 
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production 
With the Partitioning, OLAP and Oracle Data Mining options 
JServer Release 9.2.0.1.0 - Production 

SQL> create table a as select * from dba_objects ; 

表已创建。