what is the main difference between join and subqurey?

3 Answers   Oracle,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

Is sql sequential or random?

0 Answers  

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

What is pragma exception and how, when, where us

5 Answers  

---

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is the purpose of design view?

0 Answers  

---

What is normalization? How many normalization forms are there?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

What is program debugging?

0 Answers  

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---