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
- 4193 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
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to start instance with a minimal initialization parameter file?
What is an oracle recycle bin?
What is the fastest query method to fetch data from the table?
How to create lov dynamically at runtime & attach to text field?
What is a proxy object?
What are the different types of record groups in oracle? Explain each of them
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How can we create the complete backup of data in the oracle.
What is data file?
What is the parameter mode that can be passed to a procedure?
How to convert characters to times in oracle?
What is the difference between a user and a schema in oracle?
What is the maximum number of triggers that can be applied to a single table?
Explain overloading. Can functions be overloaded?
