Interested to Buy Any Domain ? << Click Here >> for more details...
where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 4191 Views
- I also Faced
- E-Mail Answers
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 |
How to create a temporary table in oracle?
Difference between pre-select and pre-query
How to grant create session privilege to a user in oracle?
What is the difference between view and materialized view in Oracle?
How to update values on multiple rows in oracle?
what is a Nested Loop join?
what is the difference between oracle enterprise edition and oracle express edition?
What is the Tune Query
How do you store pictures in a database?
How to retrieve data from an cursor to a record?
Can we connect to ORACLE db using Windows Authentication?
What is set verify off in oracle?
Oracle General 
