Home » SQL & PL/SQL » SQL & PL/SQL » Outer Joins Concept
Outer Joins Concept [message #391999] Sun, 15 March 2009 21:35 Go to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
I want to know in what Scenarios or Situations we use OUTER JOIN CONCEPT. Explain?
Re: Outer Joins Concept [message #392001 is a reply to message #391999] Sun, 15 March 2009 21:56 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

I am sorry to see that both the SEARCH function on this forum & GOOGLE are broken for you.

Please wait while repairs are being completed.
Additional feedback will be posted as it becomes available.

When all else fails, you should Read The Fine Manuals
found at http://tahiti.oracle.com

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#sthref3175

[Updated on: Sun, 15 March 2009 22:04]

Report message to a moderator

Re: Outer Joins Concept [message #392002 is a reply to message #392001] Sun, 15 March 2009 22:51 Go to previous messageGo to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
See I asked this question to know why we are using Outer Joins.
There are some scenerious where we use Outer Join without understanding the concept how it works, in which situations we can use.

The question which i have asked is not a basic question. It increases our intelligence on the concepts.
Re: Outer Joins Concept [message #392003 is a reply to message #391999] Sun, 15 March 2009 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>There are some scenerious where we use Outer Join without understanding the concept how it works
You are using Outer Joins, but you have no idea how they work.

How do you know if the result set obtained is correct or not?

[Updated on: Sun, 15 March 2009 23:12]

Report message to a moderator

Re: Outer Joins Concept [message #392013 is a reply to message #391999] Mon, 16 March 2009 00:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer as in your previous topic:
Michel Cadot wrote on Sat, 14 March 2009 08:10
SQL Reference
Chapter 9 SQL Queries and Subqueries
Section Joins

Join Wiki page.

Regards
Michel


Did you read them?
Previous Topic: Creating Packages with multiple Procedures
Next Topic: SYSDATE
Goto Forum:
  


Current Time: Sat Dec 10 03:29:42 CST 2016

Total time taken to generate the page: 0.07900 seconds