what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 18361 Views
- HCL, LN, I also Faced
- E-Mail Answers
Answer Posted / mahesh
suppose if we have joined two tables display the both table column names whatever we are giving and incase if we are use set operators columns not displyaed both tables.only first select query columns only displayed.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to load data from external tables to regular tables?
How do I limit the number of oracle database connections generated by weblogic server?
What are the built-in functions used for sending Parameters to forms ?
Point out the difference between user tables and data dictionary?
How can I introduce multiple conditions in like operator?
What is Redo Log Buffer in Oracle?
How to create tables for odbc connection testing?
Can a formula column referred to columns in higher group ?
Can you create a synonym without having a table?
What is the string concatenation operator in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a trigger and what are its types in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to concatenate two text values in oracle?
