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 |
How do I spool in oracle?
Can we write insert statement in function in oracle?
Explain temporal data types in oracle
Can a primary key contain more than one columns?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to Truncate Table in Oracle
what is the dual table in oracle?
When a form is invoked with call_form, Does oracle forms issues a save point ?
What happens to the current transaction if the session is ended?
How to call a stored procedure inside a trigger? Give an example.
what are the database links ?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??