Question - Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
Answer -
Yes, it is possible to connect to multiple databases, at the same time, but it depends on the specific driver.
To update and extract data from the different database we can use the single statement. But we need middleware to deal with multiple databases or a single database.