where we have to use ON clause and where we have to use USING
clause in JOINS
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vipul.solanki
It gives same result.when colum name is same then we can use
Using clause
with use USING :
SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM
USING(NMENUNO);
with use ON :
SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM ON
MM.NMENUNO = MRM.NMENUNO;
Is This Answer Correct ? | 0 Yes | 0 No |
Which is better Oracle or MS SQL? Why?
How to run create database statement?
How can I get column names from a table in oracle?
How to use windows user to connect to the server?
What is an oracle user account?
How much memory your 10g xe server is using?
How do we create privileges in oracle?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
how to we delete a row using varray
How to connect to a remote server?
What are transaction isolation levels supported by oracle?
Can we use bind variables in oracle stored procedure?