What is the difference between join and union.
Answer Posted / thangamadasamy
A join selects columns from 2 or more tables. A union
selects rows
| Is This Answer Correct ? | 123 Yes | 63 No |
Post New Answer View All Answers
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Which join is like inner join?
Why is sql*loader direct path so fast?
Explain the rollback statement?
Does truncate need commit?
What is bulk collect in pl sql?
Can we use joins in subquery?
What is trigger explain it?
How can you create an empty table from an existing table?
Can we join two tables without common column?
What is the function that is used to transfer a pl/sql table log to a database table?
Can procedure in package be overloaded?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What does the hierarchical profiler does?
How do you optimize a stored procedure in sql?