what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
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 would you go about verifying the network name that the local_listener is currently using?
What is oracle rownum?
how the indexes are stored in the Oracle Database?
Can you create a synonym without having a table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the different windows events activated at runtime ?
Can you assign multiple query result rows to a variable?
What is a select query statement in oracle?
How to open and close an explicit cursor in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are the differences between number and binary_float in oracle?
What is a database schema in oracle?
What are internal user account in oracle?
What are the different types of failures that occur in Oracle database?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?