It gives same result.when colum name is same then we can use Using clause

where we have to use ON clause and where we have to use USING
clause in JOINS

Question Posted / vipul.solanki

2 Answers
4389 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

Please Help Members By Posting Answers For Below Questions

How to use values from other tables in update statements using oracle?

1158

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to start an oracle instance?

1103

How to select all columns of all rows from a table in oracle?

1132

How to put more than 1000 values into an oracle in clause?

1115

How to write a left outer join with the where clause in oracle?

1156

Design database draw er diagram for a certain scenario ?

4656

What is oracle latest version?

1174