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

How does pl sql work?

967

---

how to use 'mysql' to run sql statements? : Sql dba

1059

---

how to calculate expressions with sql statements? : Sql dba

1040

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1085

---

What is sqlite format?

1205

---

What is pl sql block in dbms?

1010

---

How do I sort a table in sql?

1051

---

What is exit statement?

1020

---

Is ms sql traffic encrypted?

929

---

What is sql and its types?

1194

---

When to use inner join and left join?

963

---

What is cursor explain with example?

992

---

Why function is used in sql?

952

---

Why is sql better than hql?

999

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1006

---