where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 4390 Views
- I also Faced
- E-Mail Answers
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
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
