Let us consider the following two tables in a relational database with the given
ID: 3591028 • Letter: L
Question
Let us consider the following two tables in a relational database with the given data:
Professor
ProfessorName
Department
University
Experience
XXX
Mathematics
Aaa
5
YYY
Computer Science
Bbb
12
ZZZ
Chemistry
Ccc
7
Researcher
ResearchTitle
AuthorName
DateOfPublication
“xyz”
XXX
10-12-2013
“123”
XXX
04-03-2012
“uvw”
ZZZ
07-09-2011
“456”
WWW
05-15-2010
Write a select query using Oracle SQL which will select data from both the given tables and show the result as: (5 point)
Professor
Title
DOP
XXX
“xyz”
10-12-2013
XXX
“123”
04-03-2012
YYY
-
-
ZZZ
“uvw”
07-09-2011
-
“456”
05-15-2010
ProfessorName
Department
University
Experience
XXX
Mathematics
Aaa
5
YYY
Computer Science
Bbb
12
ZZZ
Chemistry
Ccc
7
Explanation / Answer
select ProfessorName as Professor,ResearchTitle as Title, DateOfPublication as DOP from Researcher full join Professor.
Since when we will be using Full Joins we will have a Null when there will be no matching columns
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.