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

Can you explain what are commit and rollback in sql?

0 Answers  

---

What is a transaction and what are ACID properties?

3 Answers  

---

Explain transaction server isolation?

0 Answers  

---

Ms sql server index?

0 Answers  

---

Can a table have 2 primary keys?

0 Answers  

---

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

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

2 Answers  

---

Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---