patternMinor
Is there an equivalent to OPENROWSET in Oracle?
Viewed 0 times
openrowsetoraclethereequivalent
Problem
Is there an equivalent to OPENROWSET in Oracle?
From OPENROWSET (Transact-SQL):
This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote data by using OLE DB.
From OPENROWSET (Transact-SQL):
This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote data by using OLE DB.
Solution
Answer provided by John Eisbrener in a comment
The effective equivalent is a Database Link. Sadly there's not an identical equivalent to what
The effective equivalent is a Database Link. Sadly there's not an identical equivalent to what
OPENROWSET does in one Oracle command or statement. You have to declare the db link first before accessing it. If you don't want to edit a tnsnames.ora file, you can create the dblink using an in-line statement, which allows you to programmatically emulate OPENROWSET functionality.Context
StackExchange Database Administrators Q#145389, answer score: 3
Revisions (0)
No revisions yet.