CREATE TABLE ARTIST
(  ID          NUMBER,
   NAME        VARCHAR2(255)
)

CREATE TABLE ALBUM
(  ID          NUMBER,
   ARTIST_ID   NUMBER,
   NAME        VARCHAR2(255)
)

CREATE TABLE SONG
(  ID          NUMBER,
   ARTIST_ID   NUMBER,
   ALBUM_ID    NUMBER,
   NAME        VARCHAR2(255)
)

INSERT INTO ARTIST (ID, NAME) VALUES (1, 'New Ones')

INSERT INTO ARTIST (ID, NAME) VALUES (2, 'Adele')

INSERT INTO ARTIST (ID, NAME) VALUES (3, 'Coldplay')

INSERT INTO ARTIST (ID, NAME) VALUES (4, 'Silent')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('22',  2, 'James Bond 007: Skyfall')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('31',  3, 'Ghost Stories')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('32',  3, 'A Head Full of Dreams')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('41',  4, 'Without a Sound')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('51',  null, 'From the Unknown')

INSERT INTO ALBUM (ID, ARTIST_ID, NAME) VALUES ('61',  null, 'The Lost')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('203', 2, 22, 'Skyfall')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('301', 3, 31, 'Oceans')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('302', 3, 31, 'A Sky Full of Stars')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('303', 3, 32, 'Everglow')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('501', null, 51, 'Who''s singing?')

INSERT INTO SONG (ID, ARTIST_ID, ALBUM_ID, NAME) VALUES ('603', null, null, 'Song for Nobody')

COMMIT

SELECT * FROM ARTIST

SELECT * FROM ALBUM

SELECT * FROM SONG

Erzeugen einer neuen Tabelle auf Basis eines Selects:

CREATE TABLE PLAYLIST_ANNA      
AS       
SELECT s.ID, s.NAME FROM SONG s     
 WHERE s.ID IN (301, 302, 303, 501, 603)

Erzeugen einer zweiten neuen Tabelle auf Basis eines Selects:

CREATE TABLE PLAYLIST_MARC    
AS     
        SELECT a.ID AS "Artist ID", a.NAME AS "Artist",    
               m.ID AS "Album ID",  m.NAME AS "Album",    
               s.ID AS "Song ID",   s.NAME AS "Song"    
          FROM ARTIST a    
    INNER JOIN ALBUM m ON (m.ARTIST_ID = a.ID)    
    INNER JOIN SONG s  ON (s.ALBUM_ID = m.ID)     

SELECT * FROM PLAYLIST_ANNA

SELECT * FROM PLAYLIST_MARC

UNION ALL

SELECT a.ID,        a.NAME   FROM PLAYLIST_ANNA a 
UNION ALL 
SELECT m."Song ID", m."Song" FROM PLAYLIST_MARC m 
ORDER BY NAME

UNION

SELECT a.ID,        a.NAME   FROM PLAYLIST_ANNA a 
UNION  
SELECT m."Song ID", m."Song" FROM PLAYLIST_MARC m 
ORDER BY NAME

INTERSECT

SELECT a.ID,        a.NAME   FROM PLAYLIST_ANNA a 
INTERSECT  
SELECT m."Song ID", m."Song" FROM PLAYLIST_MARC m 
ORDER BY NAME

MINUS

SELECT a.ID,        a.NAME   FROM PLAYLIST_ANNA a 
MINUS 
SELECT m."Song ID", m."Song" FROM PLAYLIST_MARC m 
ORDER BY NAME

MINUS (andere Tabellen-Reihenfolge!)

SELECT m."Song ID", m."Song" FROM PLAYLIST_MARC m 
MINUS 
SELECT a.ID,        a.NAME   FROM PLAYLIST_ANNA a 
ORDER BY "Song"