database-link Archives

How to connect to another db using stored procedures?

By adminPosted on August 18, 2022

Question : I need to get some data from an external db and make some calculations with it in another […]

By adminPosted on June 17, 2022

Question : I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 […]

By adminPosted on May 14, 2022

Question : I have a remote odbc connexion and an MySQL database in my localhost i ask if there is […]

By adminPosted on April 15, 2022

Question : I am attempting to design a simple reporting feature for some financial market data. I have a few […]

By adminPosted on April 3, 2022

Question : I have this database which includes a couple of schemas. Say I need to access schemaONE from schemaTWO. […]

By adminPosted on March 12, 2022

Question : I’m trying to do an insert as select to a table via dblink. The query looks like this: […]

By adminPosted on November 21, 2021

Question : To begin, please keep in mind that I am a very green DBA. I have done prior research […]

By adminPosted on October 28, 2021

Question : I have a PL/SQL package that copies data from a remote DB2 database using a database link. To […]

By adminPosted on September 29, 2021

Question : Let’s say there is an Oracle database A and another Oracle database B. Our database is A. Is […]

By adminPosted on August 17, 2021

Question : I think the answer to this is no, but I could be wrong. If nothing else it might […]