Answer Posted / vasanth

Hi All....!

Natural join is the same as an equi join on (emp.deptno =
dept.deptno).

Natural joins may cause problems if columns are added or
renamed. Also, no more than two tables can be joined using
this method. So, it is best to avoid natural joins as far
as possible.

If you will come to UNION ALL.

UNION ALL query allows you to combine the result sets of 2
or more "select" queries. It returns all rows (even if the
row exists in more than one of the "select" statements.

Each SQL statement within the UNION ALL query must have the
same number of fields in the result sets with similar data
types.

For Example :-

select field1, field2, . field_n
from tables
UNION ALL
select field1, field2, . field_n
from tables;

How to return multiple rows from the stored procedure?

975

---

What is the difference between syntax error and runtime error?

1147

---

what is a composite key ? : Sql dba

1068

---

What is sqlca in db2?

974

---

Is sql open source?

979

---

Is sql a backend?

1030

---

What is Collation Sensitivity ? What are the various type ?

955

---

What is before trigger?

1007

---

What is bulk compiling in pl/sql.?

1137

---

What is ttitle and btitle?

1069

---

What view means?

984

---

What are the different types of triggers?

1139

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1138

---

What are the limitations of sql express?

1074

---

What is pl sql and why it is used for?

1114

---