Question

Oracle SQL

Step 9. Create the table below and insert data LFM MoreSkill table SkillcodeSkillname Primary KeyUnique BD Build Databases Design Databases PL/SQL Programming Machine Learning ML Step 10. Using set operations, list what skills (10a) appear in the MoreSkill that were not in Skill (10b) appear in the Skill that are not in MoreSkill (10c) appear in both Skill and MoreSkill (10d) appear in either table so you have a complete list of all skills

Answer 1

SET Operations in Oracle are supported by following commands :-

1. UNION - Combine results of two or more Select statements but remove duplicate rows.

2. UNION ALL - Combine results of two or more select statements but show duplicate rows.

3. INSTERSECT - Combine results of two or more select statements but only show rows common in both statements.

4. MINUS - Combine results of two or more select statements but only show those in the final results that are present only in the first set of result.

SQL COMMANDS

Step 9.

CREATE TABLE LFM_MoreSkill (

Skillcode varchar(50),

Skillname varchar(100),

UNIQUE(Skillname),

PRIMARY KEY(Skillcode)

);

INSERT INTO LFM_MoreSkill VALUES('BD','Build Databases');

INSERT INTO LFM_MoreSkill VALUES('DD','Design Databases');

INSERT INTO LFM_MoreSkill VALUES('PP','PL/SQL Programming');

INSERT INTO LFM_MoreSkill VALUES('ML','Machine Learning');

INSERT INTO LFM_MoreSkill VALUES('PM','Pattern Matching');

STEP 10.

10a.

SELECT * FROM MoreSkill

MINUS

SELECT * FROM Skill

10b.

SELECT * FROM Skill

MINUS

SELECT * FROM MoreSkill

10c.

SELECT * FROM Skill

INSTERSECT

SELECT * FROM MoreSkill

10d.

SELECT * FROM Skill

UNION

SELECT * FROM MoreSkill

NOTE - For any other query, Pls use the comment section.