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
How to use fetch statement in a loop?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What do database buffers contain?
What are the different editions of oracle?
Why does for update in oracle 8 cause an ora-01002 error?
How do I find the database name in oracle?
How remove data files before opening a database?
How do I learn what codesets are available in oracle?
What is archive log in Oracle?
Explain rename?
Explain the use of Merge statement in oracle 11g
How to calculate date and time differences in oracle?
What is the difference between substr & instr functions?
What is an oracle data file?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?