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
4209 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 shutdown your 10g xe server?

1155

How to create tables for odbc connection testing?

1128

How are extents allocated to a segment?

1138

What is an Oracle index?

1663

Difference between pre-select and pre-query

1117

Can we write dml statement in function in oracle?

1091

Explain the blob datatype?

1080

How to retrieve the count of updated rows?

1137

What is raw datatype in oracle?

1148

How can we force the database to use the user specified rollback segment?

1155

What are the limitations of check constraint?

1039

What is the usage of synonyms?

1155

Why do we need oracle client?

966

How do you bind variables in oracle?

990

How to convert csv to table in oracle?

1002