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 a loop in sql?

984

---

What is pl sql block in dbms?

1004

---

What are the benefits of triggers?

1172

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

998

---

What is the purpose of the sql select top clause?

1112

---

Is pl sql different from sql?

999

---

Why are indexes and views important to an organization?

956

---

How do you delete data from a table?

1039

---

Describe sql comments?

1039

---

What is transaction control language (tcl)?

1139

---

What has stored procedures in sql?

1066

---

What is sql prepared statement?

984

---

Is pl sql useful?

992

---

What is bind variable in pl sql?

1051

---

What is delimiter in pl sql?

1062

---