I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

Can you join views in sql?

0 Answers  

---

What are joins in sql?

0 Answers  

---

What is the difference between nested table and varray?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

Can we use update in sql function?

0 Answers  

---

What is union?

0 Answers  

---

What is an emotional trigger?

0 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---

How do I view a procedure in sql?

0 Answers  

---

What is sql indexing?

0 Answers  

---