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
- 4164 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 merge in oracle?
What is bind variable in oracle 11g?
How to write a left outer join with the where clause in oracle?
How to run create database statement again?
How to get the Installed Oracle Version Information ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to use subqueries with the in operator using oracle?
What is dynamic proxy?
When do you get a .pll extension in oracle? Explain its importance
How to insert multiple rows with one insert statement in oracle?
How to use values from other tables in update statements using oracle?
How would you begin to troubleshoot an ORA-3113 error?
What is recycle bin in Oracle?
How to omit columns with default values in insert statement in oracle?
How to create lov dynamically at runtime & attach to text field?
