SQL Plus - What is the condition to be follwed for the natural join syntax to be correct??

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 104 of 132

What is the condition to be follwed for the natural join syntax to be correct??

Total Answers and Comments: 3

Last Update: August 07, 2008 Asked by: rajani

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 11, 2006 06:57:21

AyanM

Member Since: July 2006 Contribution: 3

RE: What is the condition to be follwed for the natura...

While performing Natural Join please ensure that the name of the common column of both the tables are identical and their data types are also the same.

Is this answer useful? Yes | No

November 07, 2006 12:34:35

inxs92

Member Since: November 2006 Contribution: 1

RE: What is the condition to be follwed for the natura...

the column names need not be identical but the data types of the column names should be identical

select e.empno d.deptno from emp e dept d where e.dept_no d.deptno;

Is this answer useful? Yes | No

August 07, 2008 07:47:51

vishakha_jain81

Member Since: August 2008 Contribution: 6

RE: What is the condition to be follwed for the natural join syntax to be correct??

It implicitly construct the join condition on the 2 tables taking all the column with same name into consideration.Natural join is also called blind join.

select employee_id last_name department_name from employees natural join departments;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank