I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

How do I run a pl sql program?

0 Answers  

---

How to know the last executed procedure?

0 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

Which one is better sql or oracle?

0 Answers  

---

---

What is rtm in testing?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

Is primary key an index?

0 Answers  

---

Can a table have no primary key?

0 Answers  

---

What kind of join is join?

0 Answers  

---