Dblink Connection Operation Remote Database

When you need to manipulate a remote database in a database, you need to create a connection to the remote database.

The connection code is as follows:

1  Create  Public DatabaseLink Connection Name2Connect toRemote database user name identified byRemote Database Password3Using'(DESCRIPTION =4 (address_list =5 (address = (PROTOCOL = TCP) (HOST = remote Database IP address) (PORT = 1521))6                 )7 (Connect_data =8 (service_name = remote Database service name)9                 )Ten               )';

How to use:

Such as: Query the remote database of all the contents of the table Emp_jh ==>select * FROM [email protected] connection name;

Dblink Connection Operation Remote Database