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
- 4163 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
How to pass parameters to procedures in oracle?
What is analyze command used for?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to initialize variables with default values?
How to invoke the data pump export utility?
Which are the five query types available in oracle?
Can we commit inside a function in oracle?
How to run queries on external tables?
How to list all indexes in your schema?
Explain cascading triggers.
What is the string concatenation operator in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is an oracle wallet?
What is a connect identifier?
Give the advantages and disadvantages of clusters.
