Answer Posted / lakshminarayana reddy

used to retrieve desired data from more than 1 table we use
join.
joins types:- 1.Equi join
2.non-Equi join
3.outer join
4.Self join

What is sql table?

1022

---

What is the difference between row level and statement level trigger?

1072

---

How do I trace sql profiler?

1046

---

Show how functions and procedures are called in a pl/sql block.

1188

---

how to get a list of all tables in a database? : Sql dba

1031

---

What is composite data type in pl sql?

1170

---

Is pl sql still used?

1018

---

Which is faster joins or subqueries?

1037

---

What is application trigger?

1056

---

Is sql port 1433 encrypted?

1087

---

Does execute immediate commit?

1291

---

What is a temp table?

1074

---

What is data control language?

1034

---

How can you create an empty table from an existing table?

1129

---

What are the different types of constraints?

1282

---