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
- 4036 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 many types of table in Oracle?
why dont we assign not null constraint as table level constraint.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What are the limitations of check constraint?
How to shutdown your 10g xe server from command line?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to define a data field as not null?
What is a named program unit?
Explain the use of inctype option in exp command.
How to define an oracle cursor variable?
What is literal?
Why cursor variables are easier to use than cursors?
What is bulk copy or bcp in oracle?
Explain oracle’s system global area (sga).
What do you mean by merge in oracle?
