Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know if UNION ALL and Natural Join does the
same operation and are same...
- 7 Answers
- 14610 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / swathi
no,both are not same.we are using the union all condition ,we will get the duplicate columns and which field we are selecting it get the total information of that ,But by using Natural join we can't get the all information,some columns are removed.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Difference between global and parameter variables?
What is difference between pls_integer and integer?
Are subqueries better than joins?
Can delete statement be rollbacked?
How do I filter in sql profiler?
what is a constraint? Tell me about its various levels. : Sql dba
Explain ddl statements in pl/sql?
What is rename command in sql?
Does sqlite need a server?
What is update query?
What is indexing oracle sql?
what is an extent ? : Sql dba
Does oracle roll back the transaction on an error?
Why do we use subquery?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
