what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
Answer Posted / pandarinath
joins project the data from more than one table vertically
based on common cloumns among the tables.
in case of set operators, its combine(merge) data horizantally, programer have to manage the correct logic and sence in the data. set operators uses for data presentation.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
How to create a table index?
How to divide query output into groups in oracle?
Explain the truncate in oracle?
What is connection pooling in oracle?
What is oracle instant client?
What is an Oracle index?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Explain overloading. Can functions be overloaded?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is the usage of control file in oracle?
definition of cluster and non-clustered index?
How can we view last record added to a table?
What is rowid and rownum in oracle?
How to assign a table row to a record variable?