where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 3235 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 |
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is bulk copy or bcp in oracle?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What are the database administrators utilities available?
What is key preserved table?
How to open a cursor variable?
What is open database communication (odbc) in oracle?
How to define an anonymous block?
What are the different type of Segments ?
How to view the tablespaces in the current database?
Why we use bulk collect in oracle?
can u call user defined functions in select statements
Oracle General 
