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
4045 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

Is the After report trigger fired if the report execution fails ?

2877

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1056

Is a rollback possible to any savepoint?

998

What is a nvl function?

956

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2307

What is oracle and what are its different editions?

1007

what is the dual table in oracle?

932

Can I create users through internet explorer in oracle 10g?

1018

How many memory layers are in the oracle shared pool?

1104

What is memory advisor in Oracle?

1023

Explain user account with reference to oracle.

927

What is the implicit cursor in oracle?

1036

Hi Can any one tell me what are the API's used in requisition import.

1879

Will you be able to store pictures in the database?explain.

928

How to upsert (update or insert into a table)?

951