What are joins..how many types of joins are there?
- 29 Answers
- 76739 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / suresh
Joins are used to fetch a query on more than one table.
You can broadly catagorize joins in to four types.
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
| Is This Answer Correct ? | 140 Yes | 34 No |
Post New Answer View All Answers
What is oracle thin client?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is integrity and what is constraint??Explain with example
Where is the export dump file located?
how may join possible between (requisition with purchase order)
What are a collation and state the different types of collation sensitivity?
Please explain joins in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
what are the default admin accounts in Oracle 10g ?
How to use windows user to connect to the server?
How to create a server parameter file?
How to create additional tablespaces for an new database?
What is oracle in java?
How to delete an existing row from a table in oracle?
Which is faster join or subquery in oracle?
