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).

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

What is Deadlock?

4 Answers   Satyam,

---

What is difference between equi join and natural join?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---

What is transact-sql language?

0 Answers  

---

Can we store videos inside the sql server table?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

What is a select query statement in ms sql server?

0 Answers  

---