What is outer join, Database Management System

What is Outer join?

 They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of whether or not they have matching tuples in the other relation.

Posted Date: 5/6/2013 3:28:19 AM | Location : United States







Related Discussions:- What is outer join, Assignment Help, Ask Question on What is outer join, Get Answer, Expert's Help, What is outer join Discussions

Write discussion on What is outer join
Your posts are moderated
Related Questions
Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

Probelm: a) In the context of OODBMS, define the following terms with appropriate examples. (i) Object class. (ii) Abstract class. (iii) Aggregation. (iv)

Explain ODBC? ODBC - Open DataBase Connectivity (ODBC) enable the integration of SQL along with a general-reasons programming language.

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

Which component is not included in database environment ? A users component is not included in database environment.

Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.