Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 19537 Views
- HCL, LN, I also Faced
- E-Mail Answers
Answer Posted / amretha
For set operators the columns in the tables must be the same.Where as for Joins if one column is same its enough to join two or more tables.
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
What are a collation and state the different types of collation sensitivity?
Why do you use stored procedures and state some of its disadvantages?
Briefly explain what is literal? Give an example where it can be used?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are the general rules on data consistency?
Can the query output be sorted by multiple columns in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is memory advisor in Oracle?
How can I get column names from a table in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
What is procedure overloading in oracle?
What is a user role in oracle?
Explain the use of indexes option in exp command.
How can I create database in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
