Answer Posted / vikneswaran

no,union all and natural join is not same. for example tave
two tame emp and dept

emp table

empid ename salary
1 a 1000
2 b 2000

dept table
deptid deptno
1 10
2 20
if i join this two tables
(empid = deptid)

empid ename salary deptno
1 a 1000 10
2 b 2000 20

if i union a11 this two tables

empid ename salary deptno
1 a 1000 null
2 b 2000 null
1 null null 10
2 null null 20
so join and unionall is not same

What is record in pl sql?

595

---

What is the sql*loader? : aql loader

590

---

How do you create an update query?

525

---

What is field delimiter?

637

---

What is the need of a partition key?

536

---

---

What is Materialized View? In What Scenario we Use Materialized View?

8531

---

Could you please provide oca (oracle 10g) dumps for my certification ?

4515

---

Can we call stored procedure in function?

553

---

How can we optimize a sql query?

577

---

What is the difference between inner join and natural join?

513

---

Which join is like inner join?

564

---

What is cost in sql execution plan?

490

---

What does bitemporal mean?

599

---

What is sql integrity?

585

---

What is number function in sql?

528

---