Answer / Rajendra Kumar Akela

No, NATURAL JOIN and INNER JOIN are not the same. By default, an INNER JOIN returns rows when there is a match in all joined columns with similar names. A NATURAL JOIN, on the other hand, performs an INNER JOIN using implicitly defined join conditions based on column names that exist in both input tables.

what is rollback? : Sql dba

1 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

What are analytic functions in sql?

1 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

what is the difference between union and union all? : Sql dba

1 Answers  

---

How to return multiple records from procedure?

2 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

1 Answers  

---

Which normal form is best?

1 Answers  

---

what is heap table? : Sql dba

1 Answers  

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---