where we have to use ON clause and where we have to use USING
clause in JOINS
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 happened to the global index when I truncate the data in one of the partition?
What is a select query statement in oracle?
How to work with data objects interactively?
What is sequence?
What is redo log?
How to write a query with an inner join in oracle?
How do I start tns listener?
does the query needs a hint to access a materialized view?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to write date and time literals in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where do you use decode and case statements?
What is a parameter file in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
How to put more than 1000 values into an oracle in clause?