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
- 4042 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
What do you understand by database schema and what does it hold?
What is sequence?
How to define a cusotmer as a supplier in ORACLE R12
What types of joins are used in writing subqueries?
How do I uninstall oracle client from windows?
How to rename an existing table?
What are the differences between char and varchar2 in oracle?
What is a package in oracle?
What is recycle bin in Oracle?
How to display row numbers with the records?
how do u setup a replication site?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to assign values to variables?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain implicit cursor.
