| database links [message #147516] |
Fri, 18 November 2005 00:45  |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
Hi all
Can anybody please tell me the
Basic description about Database Links with some examples
Bye
Subbu
|
|
|
|
| Re: database links [message #147532 is a reply to message #147516] |
Fri, 18 November 2005 02:09  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Try the SQL Reference Guide - it contains an excellent description of DB Links with some very good examples. Everything you need plus more...
Best regards.
Frank
|
|
|
|
|
|
| Re: database links [message #147604 is a reply to message #147516] |
Fri, 18 November 2005 08:55 |
ramsat
Messages: 49
Registered: November 2005
|
Member |
|
|
Hai say for eg u have 2 Db one North and another south
say r the admin of North and if u want to access the details of a schema 'user1' available in south then this is the way
sql> create database link mylinik
connect to user1 identified by passwd
using south;
now say user1 has atable called employye in south database then
sql> select * from employees@mylink;
In case of any problem hit my mailid ramesh_g@kappsoft.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
