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
- 4073 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 |
What are the uses of linked server and explain it in detail?
what is the bitmap index?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What are the common oracle dba tasks?
How to revoke create session privilege from a user in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Whats the benefit of dbms_stats over analyze?
How to join two tables in a single query using oracle?
What happens if variable names collide with table/column names?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is private procedure oracle?
How do you ensure database security?
Oracle General 
