where we have to use ON clause and where we have to use USING
clause in JOINS
- 2 Answers
- 3644 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 is bulk load in oracle?
How to convert a string to a date in oracle database?
How do I manually uninstall oracle client?
Explain database link?
Query to retrieve record for a many to many relationship ?
How to define default values for formal parameters?
What is columnar storage what is the advantage?
what is the dual table in oracle?
Which is better Oracle or MS SQL? Why?
How to drop an index in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
Give the various rollback segment states.
Why does oracle 9i treat an empty string as null?
Is there any function in oracle similar like group_concat of mysql?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
