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
How to create a table interactively?
What are the execution control statements in oracle?
Query to retrieve record for a many to many relationship ?
How to delete a column in an existing table in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What is oracle latest version?
what is the difference between substr and instr function in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the disadvantage of User defind function?
How to see the table columns used in an index?
State the difference between a primary key and foreign key?
When do you get a .pll extension in oracle?
How to add a new column to an existing table in oracle?
What is redo log?
How to speed up webrick?