Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: How to query a remote database?

Re: How to query a remote database?

From: Sumit Singh <chadhasumit13_at_hotmail.com>
Date: 19 May 2004 22:45:35 -0700
Message-ID: <1ca39d4e.0405192145.5a5c3fc5@posting.google.com> 





pelekhl_at_msn.com (lev) wrote in message news:<63dbca9c.0405190830.12c62ea8_at_posting.google.com>...


> Hello,

> 

> Is there an ad hoc way to query a remote database in Oracle a la

> OPENROWSET statement in MS SQL? Thank you.

> 

> Lev




hi,


U can make use of database links to access remote database from your database.
Look for command "Create Database Link" in documentation.
Thanx
Received on Thu May 20 2004 - 00:45:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US