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 do you use collections in procedure to return the resultset?

2237

---

What is procedure and function in sql?

997

---

What are the advantages of sql?

1055

---

How many sql statements are used? Define them.

1035

---

What is insert command in sql?

1123

---

I need a function for a train ticket reservation please answer it thanks in advance

1024

---

What is pls_integer in pl sql?

1103

---

Can a varchar be a primary key?

1009

---

What is data profiling in sql?

1074

---

What are the two characteristics of a primary key?

970

---

What is difference between sql and oracle?

1123

---

What is blind sql injection?

1070

---

What is a recursive stored procedure?

1177

---

discuss about myisam index statistics collection. : Sql dba

950

---

Can we use ddl commands in pl sql?

1160

---