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
- 4311 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 |
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the types of synonyms?
How to invoke the data pump export utility?
What are the advantages of oracle?
Whether any commands are used for months calculation? If so, what are they?
7. Repeat query (7) but also display all clients who have never ordered anything.
How to retrieve the count of updated rows?
what are the disadvantages of hierarchial database over RDBMS?
how to find out second largest value in the table
Explain about the analyze command in oracle?
What are the different pseudo commands? Explain in general?
How to define a variable of a specific record type?
Oracle General 
