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 a Tablespace?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
can you write commit in triggers?
How to assign values to variables?
Give the various exception types.
How to convert characters to dates in oracle?
How do we switch from init.ora file to asp file?
What is an Integrity Constrains ?
How to export several tables together?