Answer Posted / arkchowdary
Joins-------------------- We have
Equi join,
Non-Equi Join,
Outer Join,
Self Join,
Cartesian Join.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What types of joins are used in writing subqueries?
What are the different types of trigger and explain its various uses and functions?
What is tns name?
What is Trigger in Oracle?
Explain self joins in oracle?
What is a package ? What are the advantages of package ?
How can we find out the duplicate values in an oracle table?
Whether any commands are used for months calculation? If so, what are they?
Why packages are used in oracle?
What is transport network substrate (tns) in oracle?
What is the exact use of Collections?
What is the usage of synonyms?
List out the difference between commit, rollback, and savepoint?
What is a subquery?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
