How to query a remote database?

lev

Hello,

Is there an ad hoc way to query a remote database in Oracle a la
OPENROWSET statement in MS SQL? Thank you.

Lev

Jul 19 '05 #1

Sumit Singh

pe*****@msn.com (lev) wrote in message news:<63**************************@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

Jul 19 '05 #2