Answer / m haribaskar

Create Database Link <<LinkName>>
Connect to <<USerName>>
Idenitfied By <<PAssword>>
Using <<DATABASE_NAME>>

Answer / gaurav gupta

CREATE PUBLIC DATABASE LINK remote
USING 'remote';

Why do we use procedures?

0 Answers  

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

What are the parts of a basic sql query?

0 Answers  

---

Are sql views compiled?

1 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

How to display the current date in sql?

0 Answers  

---

What is a clob in sql?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

What is differance unique key and primary key.

7 Answers   EDS,

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---