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 |
Explain the use of record length option in exp command.
In Oracle 9i what does "i" Stands for?
How to define a sub function?
Explain the dml?
What is an oracle cursor variable?
How to count duplicated values in a column in oracle?
How to set up autotrace for a user account?
What are the tools for Oracle ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
What is an Extent ?