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

How to use clusters?

0 Answers   Amdocs,

---

List some case manipulation functions in sql?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

---

Why do we use stored procedures in sql server?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

Detail about query optimizer?

0 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What is the difference between varchar and varchar types?

0 Answers  

---

What the different components of Replication and what is their use?

0 Answers  

---