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
- 4307 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
Is it possible to split the print reviewer into more than one region ?
How do you bind variables in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to export data with a field delimiter?
types of indexes and the rationale behind choosing a particular index for a situation.
What is the difference between translate and replace in oracle?
Explain the features of oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How does Oracle guarantee data integrity of data changes?
Define oracle database
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Explain constraining triggers.
Can you create a synonym without having a table?
ABOUT IDENTITY?
How do I call oracle stored procedures that take no parameters?
