where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 3244 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 |
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to get a list of all tables in the database?
What is pragma autonomous transaction in oracle?
How many data types are supported?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain parameter file in oracle.
How much memory your 10g xe server is using?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is sharded cluster?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Oracle General 
