Home » SQL & PL/SQL » SQL & PL/SQL » Database links
Database links [message #18858] Tue, 19 February 2002 02:53 Go to next message
dhanraj
Messages: 12
Registered: February 2002
Junior Member
would you please give me a brief information about
database links with example...Thankyou
Re: Database links [message #18863 is a reply to message #18858] Tue, 19 February 2002 03:40 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
database link is used to access remote database, that means u can access one database from other using DB link.

use create database link command to create DB link.

create public database link aaa
connect to remote_db_user_name identified by remote_db_password
using 'remote_db_connectstring'

remote_db_user_name -> user name of db which u want to connect
remote_db_password -> password ,
remote_db_connectstring -> connect string
Previous Topic: searching for a ' quote through SQL
Next Topic: joins
Goto Forum:
  


Current Time: Tue Apr 23 08:53:49 CDT 2024