where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 3634 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to write date and time interval literals in oracle?
What is the oracle implicit cursor?
How to turn on or off recycle bin for the instance?
What is an index associated with a constraint?
What are the differences between char and nchar in oracle?
How to retrieve the count of updated rows?
What is a cursor in oracle?
What is a database schema in oracle?
What is primefaces used for?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What privilege is needed for a user to connect to oracle server?
How to drop an index in oracle?
Explain the use of record option in exp command.
How to use regular expression in pattern match conditions in oracle?
