Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How make remote connection in database?

Question Posted / anand.kv


How make remote connection in database?..

Answer / kalyana chakravarthy maddipati

You can make a remote connection in a database using DBLINK(Database link). it is a named object in the database.
To create a DBLINK this is the syntax

Create dblink XX(DBLInk Name) connect to USERNAME identified by PASSWORD using DATABASENAME.

To access data from remote place using DBLink this is the way

select * from table_name@xx(DBLink name).

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

What is conditional split?

0 Answers  

Explain nested trigger in sql?

0 Answers  

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

Why should we go for stored procedures? Why not direct queries?

0 Answers  

How to configure and test odbc dsn settings?

0 Answers  

What are the differences between ms sql server & oracle?

0 Answers  

What is openrowset sql server?

0 Answers  

What is the difference between count () and rowcount ()?

0 Answers  

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

Explain insert into select statement?

0 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories