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
- 4201 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
What is a user account in oracle?
What is enter substitution variable in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to bring a tablespace online?
How to use attributes of the implicit cursor in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
what is the difference between data migration and production migration.
How to work with data objects interactively?
Can we connect to ORACLE db using Windows Authentication?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is ordinary table in oracle?
What is a oracle database?
How to filter out duplications in the returning rows using oracle?
Explain temporal data types in oracle
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
