Interview Questions  
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Go Back   Interview Questions > Interview Questions & Answers > Information Technology > Databases > Oracle > Oracle General
Reload this Page What are joins? how many types of

Oracle General Oracle General Interview Questions, Learn by sharing Oracle General Interview Questions asked in various Companies, Get Career advices, Interview Procedures from Oracle General experts, Post asked Oracle General Interview Questions and Answers.

   

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-19-2008, 07:29 PM
Senior Member
  
Join Date: Mar 2008
Posts: 4,634
Default What are joins? how many types of
What are joins? how many types of joins are there?
Reply With Quote
  #2 (permalink)  
Old 07-14-2008, 06:22 PM
Member
  
Join Date: Jul 2008
Posts: 31
Default
joins are used to display or return or bring the data from more than one table.these are been categorized into
2 types:
1.oracle sysntax
cartesian join
equi joiin
self join
outer join
2.ancii syntax
cross join
natural join
join using "using clause"
join using "on clause"
left outer join
right outer join
full outer join
Reply With Quote
Reply

Tags
interview questions, oracle security

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On








Contact Us - Interview Questions and Answers Discussion Community. - Archive - Top