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
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to use subqueries in the from clause in oracle?
What is oracle and what are its different editions?
What is the difference between $oracle_base and $oracle_home?
does the query needs a hint to access a materialized view?
What is data file?
What is oracle update statement with inner join ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is the difference between translate and replace in oracle?
How do I call oracle stored procedures that take no parameters?
What is oracle database 10g express edition?
Explain the use of Merge statement in oracle 11g
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to get last row id?
query optmization techniques and quwry analyser+projects+ppts