I have table-A(1,2,3)& table-B(3,4,5).what is the different
b/w below questions?
A union all B?
B union all A?
Answers were Sorted based on User's Feedback
Answer / anuradha
For the first case it will come : 1,2,3,3,4,5
For the second case it will come: 3,4,5,1,2,3
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / sudipta santra
For the first case it will come : 1,3,2,5,3,4
For the second case it will come: 5,3,4,1,3,2
No logic behind that .
| Is This Answer Correct ? | 3 Yes | 9 No |
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
what is candidate key & super key
Explain about achiever in sql?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Please explain oracle data types with examples?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How to drop an index?
What is varray?
What is the difference between Sleep and Wait? (Java)
What is the use of oracle?