Over a million developers have joined DZone.

Right Outer Join in SQL / Oracle Database

Thrive in the application economy with an APM model that is strategic. Be E.P.I.C. with CA APM.  Brought to you in partnership with CA Technologies.

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);





 

Navigate the Maze of the End-User Experience and pick up this APM Essential guide, brought to you in partnership with CA Technologies

Topics:

Published at DZone with permission of Achala Chathuranga Aponso, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}