where we have to use ON clause and where we have to use USING
clause in JOINS
Answer Posted / saiprasanna
in ansi style the join condn can be given bu using "ON-clause"
or by using "USING-clause".
"USING" clause can be used if common column name is same other
wise "ON" clause is used.
ex:-select e.ename,d.dname from emp e join dept d on e.deptno
=d.deptno;
select e.ename,d.dname from emp e join dept d using(deptno);
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain oracle instance.
What is the exact use of Collections?
What is SQL Tuning Advisor in Oracle?
What is analyze command used for?
Explain what are the characteristics of data files?
Differentiate between translate and replace?
How to declare a local variable?
How oracle handles dead locks?
How to create a table index in oracle?
What are the general rules on data consistency?
What are the different types of synonyms?
How many data types are supported?
What is the data type of dual table?
Explain the use of Merge statement in oracle 11g
How to use existing values in update statements using oracle?