The example connects to a service named xe running on port 1521 (on the localhost) with a user name of hr and a password of pwd. You can use the connection name acctg
to refer to this connection when calling other dblink_ora functions.
The following command uses the dblink_ora_copy() function over a connection named edb_conn to copy the empid and deptno columns from a table (on an Oracle server) named ora_acctg to a table located in the public schema on an instance of Advanced Server named as_acctg. The TRUNCATE option is enforced, and a feedback count of 3 is specified:
The following SELECT statement uses dblink_ora_record() function and the acctg connection to retrieve information from the Oracle server: