Name: Create database link
Author:
Language: Oracle
Description:
Create an Oracle database link to use tables from a different database than you're working in.
Snippet:
CREATE DATABASE LINK
name_of_link
CONNECT TO
oracle_username
IDENTIFIED BY
password -- no quotes here
USING
'database_sid' -- single quotes here
/
-- test
select * from dual@name_of_link
/