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
- 4216 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 write date and time interval literals in oracle?
How to loop through a cursor variable?
What are the different types of databases?
How to drop an existing view in oracle?
What are the general rules on data consistency?
What are the types of Database Links ?
Explain constraining triggers.
How to run the anonymous block again?
Explain the dml?
Explain an index segment?
What privilege is needed for a user to create views in oracle?
What are the system predefined user roles?
Oracle General 
