what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
Answer Posted / jyoti
Set - Comparison is to be performed on Tables.
Join- Comparison is to performed on rows of tables.
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to define a variable to match a table column data type?
What is logical backup in oracle?
Can a formula column be obtained through a select statement ?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to create a single index for multiple columns?
Explain what are clusters?
Why use resource manager in Oracle?
what are bitmap indexes? How does they work?
What the is the diff between local index and global index. give some example.
What are the restrictions in a oracle read only transaction?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the different types of database objects?
State some uses of redo log files?
Can group functions be used in the order by clause in oracle?