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
- 4305 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 do a full database export?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
does the query needs a hint to access a materialized view?
What is index in Oracle?
How to define an external table with a text file?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are a query and state the different types of queries and their uses?
How do I reset a sequence in oracle?
Is insert autocommit in oracle?
What is a trigger oracle?
Difference between varchar and varchar2 data types?
How to define a variable of a specific record type?
Explain the use of rows option in exp command.
what is reindexing?
