What are joins..how many types of joins are there?
- 29 Answers
- 76697 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / keshavenas
Basically join's are three type's those are :
1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.Full outer join
d.Self join
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How would you begin to troubleshoot an ORA-3113 error?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the difference between count (*), count (expression), count (distinct expression)?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Why do we need oracle client?
How to create a new oracle data file?
What is the usage of merge statement?
How to invoke the data pump export utility?
What is the difference between $oracle_base and $oracle_home?
What is using clause and give example?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
definition of cluster and non-clustered index?
What is meant by joins?
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?
How to shutdown your 10g xe server?
