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 user defined functions?

746

---

What is sql data?

706

---

Is mariadb a nosql database?

760

---

What are stored procedures used for?

729

---

What are the types pl/sql code blocks?

795

---

---

How to read xml file in oracle pl sql?

691

---

Describe sql comments?

728

---

Do stored procedures prevent sql injection?

725

---

what are the t string functions available in tsql? : Transact sql

735

---

Is oracle and sql same?

745

---

How delete all data from all tables in sql?

685

---

Can you sum a count in sql?

737

---

What is date functions?

729

---

What is pragma in sql?

818

---

What are aggregate functions in sql?

840

---