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
- 4192 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 reindexing?
What is difference between sid and service name in oracle?
How to delete multiple rows from a table in oracle?
How to view existing locks on the database?
what are the default admin accounts in Oracle 10g ?
What are the components of logical database structure in oracle database?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to update values on multiple rows in oracle?
What is background process in Oracle?
What is materialized view in Oracle?
How many types of tables are there in oracle?
Explain the use of record option in exp command.
What are the varoius components of physical database structure of oracle database?
How can we create the complete backup of data in the oracle.
