Right Outer Join in SQL / Oracle Database
Right Outer Join in SQL / Oracle Database
Join the DZone community and get the full member experience.
Join For FreeBuild vs Buy a Data Quality Solution: Which is Best for You? Gain insights on a hybrid approach. Download white paper now!
This can be used to demonstrate the Right outer join. ( Demonstrated using Oracle Database )
CREATE TABLE emp
(
emp_id NUMBER(2) CONSTRAINT emp_col1_pk PRIMARY KEY,
emp_name VARCHAR2(20),
emp_salary NUMBER(5)
);
CREATE TABLE dept
(
dept_id NUMBER(2) CONSTRAINT dept_coll_pk PRIMARY KEY,
dept_name VARCHAR(20),
emp_id CONSTRAINT dept_col3_fk REFERENCES emp(emp_id)
);
-- Insert---
INSERT INTO "HR"."EMP" VALUES('1','Achala','1500');
INSERT INTO "HR"."EMP" VALUES('2','ach','1000');
INSERT INTO "HR"."EMP" VALUES('3','Tendulkar','20000');
INSERT INTO "HR"."EMP" VALUES('4','Jayasuriya','2000');
INSERT INTO "HR"."DEPT" (DEPT_ID,DEPT_NAME,EMP_ID) VALUES('1','Sports','1');
INSERT INTO "HR"."DEPT"(DEPT_ID,DEPT_NAME,EMP_ID) VALUES('2','Accounts','2');
INSERT INTO "HR"."DEPT" (DEPT_ID,DEPT_NAME,EMP_ID)VALUES('3','Sales','3');
INSERT INTO "HR"."DEPT" (DEPT_ID,DEPT_NAME) VALUES('4','Marketing');
INSERT INTO "HR"."DEPT" (DEPT_ID,DEPT_NAME) VALUES('5','Finance');
select * from emp;
select * from dept;
SELECT emp_name,dept_name FROM dept RIGHT OUTER JOIN emp ON (emp.emp_id = dept.emp_id);
SELECT emp_name,dept_name FROM dept RIGHT OUTER JOIN emp using (EMP_ID);
Build vs Buy a Data Quality Solution: Which is Best for You? Maintaining high quality data is essential for operational efficiency, meaningful analytics and good long-term customer relationships. But, when dealing with multiple sources of data, data quality becomes complex, so you need to know when you should build a custom data quality tools effort over canned solutions. Download our whitepaper for more insights into a hybrid approach.
Like This Article? Read More From DZone
Published at DZone with permission of Achala Chathuranga Aponso , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}