Oracle DB Link Usage

[bandarna]

Can any one write simple select statement showing how to use db link in oracle statement?

for ex. I am in shema B and I wanted to get data from Table T1 from shema A (consider db link name as o20d_link).

Select * from T1@o20d_link is it currect?

 

[Turkbear]

Hi,
For schemas in the same database instance, no DB link is needed...Just use

select * from A.T1;

( Assumes user logged ( B, maybe) in has permission to do that granted by the A user.)


If in a different instance, then after defining the DB link ( sort of like this):

create public database link odata connect to <user> identified by <pass> using 'tnsnames.ora alias';

then
you would use:

select sysdate from dual@odata;

To Paraphrase:"The Help you get is proportional to the Help you give.."