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 difference between replace() and translate() functions in oracle?
What do you mean by merge in oracle and how can you merge two tables?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
How do we represent comments in oracle?
What is a proxy object?
What are the differences between char and varchar2 in oracle?
what is the exact definition for pointer?
how to find the n'th highest salary from emp ?
How to use "if" statements on multiple conditions?
Can you use a commit statement within a database trigger?
Why does Oracle not permit the use of PCTUSED with indexes?