Subasini

• Nov 17th, 2006

 

Data base link is a Database object .

Basically we use it when we require to connect to other user or any remote user from current user.

Syntax for creation is

Create database link link_name connect to user_name identified by password using current_user_name.

when you fetching some data from other user.

select * from table_name@database_link_name.

By time of dropping dblink syntax is

DROP PUBLIC DATABASE LINK Link_name;

We can see the existing dblink through USER_DB_LINKS data dictionary view or

ALL_DB_LINKS data dictionary views

Thanks

Subasini

raghu

• Nov 22nd, 2006

 

hii think u studied in sree nipuna technologies right..............