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
- 4044 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 is the difference between table and veiw?
What are the advantages of Views ?
How to assign values to variables?
Can multiple cursors being opened at the same time?
What is BBED in Oracle?
How to invoke the original export import utilities?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
how to retrieve 1st and last row of table without using group functions??
How are Indexes Update ?
what is null value?
What are the components of Physical database structure of Oracle Database?
How to restrict the duplicate records in table valuesets
Oracle General 
