Imran_Javed

 Profile Answers by Imran_Javed 

• May 8th, 2008

 

Use DB link to get data from 2 different DB on 2 different server.

For example, if there are 2 DB, DB1 and DB2

Then create a link with name “DB2” in DB1.
After that you can query DB2 tables

In DB1, you can do

Select * from EMP e, dept@DB2 d

Where e.deptno = d.deptno;

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

you can use join

Sujaya

• Jun 8th, 2012

 

SELECT Ename, DeptNo, Sal, Emp.DeptNo, Dept.Dname, Dept.Loc, Dept FROM
Emp, Dept
WHERE Emp.DeptNo = Dept.DeptNo;