For this example, you need to create three Oracle databases, a United States database, a United Kingdom database, and a Canadian database. Each database has a Cust table that contains the customer data for the region.
The following SQL statements create a Cust table on an Oracle database:
Create table Cust (CustomerId number,CustomerName varchar2(25),PhoneNumber varchar2(15),Email varchar2(25));
This example includes three databases to illustrate dynamic database connections. If the tables are in the same database, use a static database connection to improve performance.