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
- 4206 Views
- I also Faced
- E-Mail Answers
Answer Posted / saiprasanna
in ansi style the join condn can be given bu using "ON-clause"
or by using "USING-clause".
"USING" clause can be used if common column name is same other
wise "ON" clause is used.
ex:-select e.ename,d.dname from emp e join dept d on e.deptno
=d.deptno;
select e.ename,d.dname from emp e join dept d using(deptno);
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between post-database commit and post-form commit?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What happens to the data files if a tablespace is dropped?
How will you identify oracle database software release?
What is rich query?
How to define an anonymous procedure with variables?
What are the oracle differences between nvl and coalesce
interview questions with answer for cts
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is the difference between count (*), count (expression), count (distinct expression)?
how the indexes are stored in the Oracle Database?
What are joins, explain all types of joins?
How to define and use table alias names in oracle?
ABOUT IDENTITY?
How to sort the query output in oracle?
