Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96978 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth keshavena
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
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
How to revoke create session privilege from a user in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to convert dates to characters in oracle?
what are bitmap indexes? How does they work?
How to create lov dynamically at runtime & attach to text field?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain about your project and its relation to the current job position you are applying to?
What is data file?
What is backup in Oracle?
Can we write dml statement in function in oracle?
How do I connect to oracle database?
How to define a sub function?
What is bulk load in oracle?
What is the parameter mode that can be passed to a procedure?
