Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179569 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / mohan
join is used to combine two different tables where as in union
union also perform the same operation but the difference is
union will return distinct(unique) values.we can eliminate
the duplicate records while using union
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is bind reference and how can it be created?
What are the two virtual tables available at the time of database trigger execution?
Which one is better sql or oracle?
How can we find duplicate records in a table?
what are the features and advantages of object-oriented programming? : Sql dba
Explain select statements in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What is pls_integer in pl sql?
What is a pdo connection?
What is the starting oracle error number? What is meant by forward declaration in functions?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How we can update the view?
Why triggers are used?
what is self-join? : Sql dba
What are tables in sql?
