Oracle PL/SQL: Database Link - Database Links are used to communicate between different databases.<br /> <br /> A database link d

Quick Search:

Oracle PL/SQL: Database Link

Jump to:

Category: >> Oracle PL/SQL >> Database Link

<< last

next >>

Snippet Name: Database Link

Description: Database Links are used to communicate between different databases.

A database link defines a network connection, and, optionally, a username, to use in contacting a remote database. The purpose of using a link is to isolate SQL statements from the underlying, physical network topology. If the location of a remote database changes, only the link need be updated.

Also see:
» Database Links: Close Database Link
» Create Database Link
» Create DB Link

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

CURRENT USER
     CREATE PUBLIC DATABASE LINK link_name
     CONNECT TO current_user
     USING service_name;
 
     CREATE DATABASE LINK link_name
     CONNECT TO current_user
     USING service_name;
 
 
Connected USER
     CREATE PUBLIC DATABASE LINK link_name
     USING service_name;
 
     CREATE DATABASE LINK link_name
     USING service_name;
 
 
Fixed USER
     CREATE PUBLIC DATABASE LINK link_name
     CONNECT TO user_name
     IDENTIFIED BY password
     USING service_name;
 
     CREATE DATABASE LINK link_name
     CONNECT TO user_name
     IDENTIFIED BY password
     USING service_name;