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 |
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to call a trigger inside a stored procedure?Give an example.
can we pass two out parameters at a time in function?please answer to my question
How to get execution statistics reports on query statements?
Explain database link?
What are advantages fo Stored Procedures?
Explain the difference between sap and oracle?
How to create a testing table in oracle?
Explain what are the different type of segments?
Can I create users through internet explorer in oracle 10g?
what is the syntax of SELECT command?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??