Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
types of joins in Oracle9i with ex.
This is a discussion on types of joins in Oracle9i with ex. within the Oracle forums, part of the Databases category; can anyone tell me about the types of joins in oracle9i with ex. plz clear the concept...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
08-06-2009
|
|||
|
|||
Re: types of joins in Oracle9i with ex.
1. Inner Join
2. Outer Join 3. Cross Join 4. Natural Join 5. Left 6. Right 7. Full Outer join hope this much will helpful for u..... 
|
|
08-28-2009
|
|||
|
|||
|
Re: types of joins in Oracle9i with ex.
The basic defination is "Whenever you are fetching records from more than one table, the condition or link you are providing between tables is known as JOIN". And if you not using any condition or link then it will fetch all the records from the tables in a one to many base relationship, which is nothing but cartesian product. So in order to avoid cartesian product issue generally we go for a JOIN. Now if you are fetching records from a single table by using some other column of the same table then also it comes under a JOIN called Self JOIN.
|
| The Following User Says Thank You to Yajnas For This Useful Post: | ||
|
|
«
character
|
OCA Certification
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| oracle9i | snehaltamhane | Oracle | 2 | 01-11-2009 05:51 AM |
| Types of Joins in SQL | Adarsh B | SQL Server | 5 | 07-24-2008 02:21 AM |
| Joins | udaykumarn | Oracle | 1 | 07-01-2008 10:15 PM |
| oracle9i | rishi_saurabh | SQL | 3 | 06-05-2008 01:27 AM |
| Types of Joins | jyoti_02 | SQL | 1 | 05-10-2008 06:53 AM |
All times are GMT -4. The time now is 06:00 AM.
