- Data Base Link provides you the control on the tables from other database.
- It allows you to query against other databases using the syntax TABLENAME@DBLINK.
- Use the following code to create a database link:
create database link "database_link_name"
connect to username
identified by "password"
create database link "HRDEV"
connect to sysadm
identified by "sysadm"
- We can select any record from HR89DEV database.
- SELECT * FROM PS_JOB@HRDEV;