is it possible to scope a view to a package like you would do with functions and/or procedures? I have a number of related views that I'd like to group together.
I am running oracle 9i and want to connect to a sql server database, and possibly link to it. Anyone know how? Similar to an oracle db link where you can join tables across oracle databases?
Can anyone give a newbie a method for running a distributed query across multiple databases?
for example:
select *
from database1.table db1, database2.table db2
where db1.some_column=db2.some_column
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.