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,

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

How can we debug in PL/SQL?

0 Answers  

---

What is not equal in sql?

0 Answers  

---

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

---

Explain isolation levels. : Transact sql

0 Answers  

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---