Music Schema Data Generation: SONGANDTRACK.SQL

SPOOL log/SONGANDTRACK.LOG;
SET ECHO OFF
--Soak up the Sun by Sheryl Crow
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE, PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Soak Up The Sun (Album Version)','11:20');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE, PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Soak Up The Sun (Sunsweep Radio Mix)','3:20');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Soak Up The Sun (Sunsweep Club Mix)','22:30');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE, PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Soak Up The Sun (Sunsweep Dub)','15:30');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Soak Up the Sun')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Album Version)'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Soak Up the Sun')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Sunsweep Radio Mix)'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Soak Up the Sun')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Sunsweep Club Mix)'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Soak Up the Sun')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Sunsweep Dub)'),4);
COMMIT;
--Complicated by Avril Lavigne
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST
WHERE NAME='Avril Lavigne'),'Complicated');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Complicated')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Complicated'),1);
COMMIT;
--Here is Gone Pt.1 by Goo Goo Dolls
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Here Is Gone');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'We Are The Normal');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Burnin Up');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Video');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.1')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Here Is Gone'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.1')
,(SELECT SONG_ID FROM SONG WHERE TITLE='We Are The Normal'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.1')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Burnin Up'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.1')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Video'),4);
COMMIT;
--Here is Gone Pt.2 by Goo Goo Dolls
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Here Is Gone Reprise');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Two Days In February');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Goo Goo Dolls')
,'Girl Right Next To Me');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.2')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Here Is Gone Reprise'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.2')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Two Days In February'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Here Is Gone Pt.2')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Girl Right Next To Me'),3);
COMMIT;
--Cmon Cmon by Sheryl Crow
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Steve McQueen','3:25');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Soak Up The Sun','4:52');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'You''re An Original','4:18');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Safe And Sound','4:32');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'C''mon, C''mon','4:45');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'It''s So Easy','3:24');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Over You','4:38');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Lucky Kid','4:02');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Diamond Road','4:09');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'It''s Only Love','5:05');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Abilene','4:05');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Hole In My Pocket','4:37');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sheryl Crow')
,'Weather Channel','4:40');
COMMIT;
--Mozart: Requiem
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: I. Introitus - Requiem');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: II. Kyrie');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No.1 - Dies irae');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No. 2 - Tuba mirum');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No. 3 - Rex tremendae');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No. 4 - Recordare');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No. 5 - Confutatis');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: III. Sequenz - No. 6 - Lacrimosa');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: IV. Offertorium - No. 1 - Domine Jesu');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: IV. Offertorium - No. 2 - Hostias');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: V. Sanctus');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: VI. Benedictus');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: VII. Agnus Dei');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Mozart'),'Requiem in D Minor: VIII. Communio - Lux aeterna');
COMMIT;
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Sweet Baby James');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Lo and Behold');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Sunny Skies');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Steamroller');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Country Road');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Oh Susanna');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Fire and Rain');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Blossom');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Anywhere Like Heaven');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Oh Baby, Don''t You Loose Your Lip on Me');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE) VALUES(SONG_ID_SEQ.NEXTVAL,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='James Taylor'),'Suite for 20 G');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Steve McQueen'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Soak Up The Sun'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='You''re An Original'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Safe And Sound'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='C''mon, C''mon'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='It''s So Easy'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Over You'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Lucky Kid'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Diamond Road'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='It''s Only Love'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Abilene'),11);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Hole In My Pocket'),12);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='C''mon, C''mon')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Weather Channel'),13);
COMMIT;
--Come Clean by Puddle of Mudd
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Control','3:50');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Drift and Die','4:25');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Out Of My Head','3:43');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Nobody Told Me','5:21');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Blurry','5:04');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'She Hates Me','3:36');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Bring Me Down','4:02');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Never Change','3:58');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Basement','4:21');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'Said','4:05');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Puddle of Mudd')
,'It All Away','5:38');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Control'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Drift and Die'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Out Of My Head'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Nobody Told Me'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Blurry'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='She Hates Me'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Bring Me Down'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Never Change'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Basement'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Said'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Come Clean')
,(SELECT SONG_ID FROM SONG WHERE TITLE='It All Away'),11);
COMMIT;
--Silver Side Up by Nickelback
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Never Again','4:20');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'How You Remind Me','3:43');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Woke Up This Morning','3:50');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Too Bad','3:52');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Just For','4:03');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Hollywood','3:04');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Money Bought','3:24');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Where Do I Hide','3:38');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Hangnail','3:54');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Nickelback')
,'Good Times Gone','5:20');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Never Again'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='How You Remind Me'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Woke Up This Morning'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Too Bad'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Just For'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Hollywood'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Money Bought'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Where Do I Hide'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Hangnail'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Silver Side Up')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Good Times Gone'),10);
COMMIT;
--Ultimate Manilow by Barry Manilow
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Mandy','3:17');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'It''s A Miracle','3:51');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Could It Be Magic','6:47');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'I Write The Songs','3:50');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Bandstand Boogie','2:50');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Tryin'' To Get The Feeling Again','3:50');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'This One''s For You','3:26');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Weekend In New England','3:45');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Looks Like We Made It','3:32');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Daybreak','3:05');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Can''t Smile Without You','3:07');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Even Now','3:26');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Copacabana (At The Copa)','5:40');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Somewhere In The Night','3:23');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Ready To Take A Chance','2:57');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Ships','4:00');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'I Made It Through The Rain','4:19');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'The Old Songs','4:41');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'When October Goes','3:58');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Barry Manilow')
,'Somewhere Down The Road','3:59');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Mandy'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='It''s A Miracle'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Could It Be Magic'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='I Write The Songs'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Bandstand Boogie'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Tryin'' To Get The Feeling Again'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='This One''s For You'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Weekend In New England'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Looks Like We Made It'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Daybreak'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Can''t Smile Without You'),11);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Even Now'),12);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Copacabana (At The Copa)'),13);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Somewhere In The Night'),14);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Ready To Take A Chance'),15);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Ships'),16);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='I Made It Through The Rain'),17);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='The Old Songs'),18);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='When October Goes'),19);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Ultimate Manilow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Somewhere Down The Road'),20);
COMMIT;
--Mad Season By Matchbox Twenty
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty'),'Angry');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'Black and White People');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty'),'Crutch');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'Last Beautiful Girl');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'If You''re Gone');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'Mad Season');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'Rest Stop');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'The Burn');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty'),'Bent');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'Bed Of Lies');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty'),'Leave');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty'),'Stop');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Matchbox Twenty')
,'You Won''t Be Mine');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Angry'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Black and White People'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Crutch'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Last Beautiful Girl'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='If You''re Gone'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Mad Season'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Rest Stop'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='The Burn'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Bent'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Bed Of Lies'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Leave'),11);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop'),12);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Mad Season')
,(SELECT SONG_ID FROM SONG WHERE TITLE='You Won''t Be Mine'),13);
COMMIT;
--This Way by Jewel
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Standing Still','4:30');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Jesus Loves You','3:20');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Everybody Needs Someone Sometime','4:08');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel'),'Break Me','4:04');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Do You Want To Play ?','2:55');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Till We Run Out Of Road','4:45');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Serve The Ego','4:57');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel'),'This Way','4:16');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel'),'Cleveland','4:09');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'I Won''t Walk Away','4:45');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Love Me, Just Leave Me Alone','3:47');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'The New Wild West','4:47');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Grey Matter (Live)','4:35');
INSERT INTO SONG(SONG_ID,ARTIST_ID,TITLE,PLAYING_TIME)
VALUES(SONG_ID_SEQ.NEXTVAL
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Jewel')
,'Sometimes It Be That Way (Live)','3:44');
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Standing Still'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Jesus Loves You'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Everybody Needs Someone Sometime'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Break Me'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Do You Want To Play ?'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Till We Run Out Of Road'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Serve The Ego'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='This Way'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Cleveland'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='I Won''t Walk Away'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Love Me, Just Leave Me Alone'),11);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='The New Wild West'),12);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Grey Matter (Live)'),13);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='This Way'),
(SELECT SONG_ID FROM SONG WHERE TITLE='Sometimes It Be That Way (Live)'),14);
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Album Version)'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG
WHERE TITLE='Soak Up The Sun (Sunsweep Dub)'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='It''s So Easy'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Over You'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Diamond Road'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Hole In My Pocket'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO)
VALUES ((SELECT MUSICCD_ID FROM MUSICCD
WHERE TITLE='The Best of Sheryl Crow')
,(SELECT SONG_ID FROM SONG WHERE TITLE='Weather Channel'),7);
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: I. Introitus - Requiem'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: II. Kyrie'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No.1 - Dies irae'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No. 2 - Tuba mirum'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No. 3 - Rex tremendae'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No. 4 - Recordare'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No. 5 - Confutatis'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: III. Sequenz - No. 6 - Lacrimosa'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: IV. Offertorium - No. 1 - Domine Jesu'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: IV. Offertorium - No. 2 - Hostias'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: V. Sanctus'),11);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: VI. Benedictus'),12);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: VII. Agnus Dei'),13);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Requiem'),(SELECT SONG_ID FROM SONG WHERE TITLE='Requiem in D Minor: VIII. Communio - Lux aeterna'),14);
COMMIT;
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Sweet Baby James'),1);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Lo and Behold'),2);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Sunny Skies'),3);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Steamroller'),4);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Country Road'),5);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Oh Susanna'),6);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Fire and Rain'),7);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Blossom'),8);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Anywhere Like Heaven'),9);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Oh Baby, Don''t You Loose Your Lip on Me'),10);
INSERT INTO CDTRACK(MUSICCD_ID,SONG_ID,TRACK_SEQ_NO) VALUES ((SELECT MUSICCD_ID FROM MUSICCD WHERE TITLE='Sweet Baby James'),(SELECT SONG_ID FROM SONG WHERE TITLE='Suite for 20 G'),11);
COMMIT;
SPOOL OFF;

Music Schema Data Generation: GUESTARTIST.SQL

SPOOL log/GUESTARTIST.LOG;
INSERT INTO ARTIST(ARTIST_ID,NAME,INSTRUMENTS)
VALUES(ARTIST_ID_SEQ.NEXTVAL,'Angie Aparo'
,INSTRUMENTSCOLLECTION('Background Vocals'));
INSERT INTO ARTIST(ARTIST_ID,NAME,INSTRUMENTS)
VALUES(ARTIST_ID_SEQ.NEXTVAL,'Peter Stuart'
,INSTRUMENTSCOLLECTION('Background Vocals'));
INSERT INTO ARTIST(ARTIST_ID,NAME,INSTRUMENTS)
VALUES(ARTIST_ID_SEQ.NEXTVAL,'Sam Bacco'
,INSTRUMENTSCOLLECTION('Percussion'));
INSERT INTO ARTIST(ARTIST_ID,NAME,INSTRUMENTS)
VALUES(ARTIST_ID_SEQ.NEXTVAL,'Tony Adams'
,INSTRUMENTSCOLLECTION('Drums'));
INSERT INTO ARTIST(ARTIST_ID,NAME,INSTRUMENTS)
VALUES(ARTIST_ID_SEQ.NEXTVAL,'Paul Doucette'
,INSTRUMENTSCOLLECTION('Acoustic Guitar'));
COMMIT;
INSERT INTO GUESTAPPEARANCE(COMMENT_TEXT,SONG_ID,GUESTARTIST_ID) VALUES('Arrived late'
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Angie Aparo'));
INSERT INTO GUESTAPPEARANCE(COMMENT_TEXT,SONG_ID,GUESTARTIST_ID) VALUES('Very professional when meeting with the band'
,(SELECT SONG_ID FROM SONG WHERE TITLE='The Burn')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Peter Stuart'));
INSERT INTO GUESTAPPEARANCE(SONG_ID,GUESTARTIST_ID)
VALUES((SELECT SONG_ID FROM SONG WHERE TITLE='Last Beautiful Girl')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sam Bacco'));
INSERT INTO GUESTAPPEARANCE(SONG_ID,GUESTARTIST_ID)
VALUES((SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Tony Adams'));
INSERT INTO GUESTAPPEARANCE(COMMENT_TEXT, SONG_ID,GUESTARTIST_ID) VALUES('Agreed to work on this song for free'
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Paul Doucette'));
COMMIT;
INSERT INTO INSTRUMENTATION
(COMMENT_TEXT,SONG_ID,GUESTARTIST_ID,INSTRUMENT_ID)
VALUES('Best crooning on the CD'
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Angie Aparo')
,(SELECT INSTRUMENT_ID FROM INSTRUMENT
WHERE NAME='Background Vocals'));
INSERT INTO INSTRUMENTATION
(SONG_ID,GUESTARTIST_ID,INSTRUMENT_ID)
VALUES((SELECT SONG_ID FROM SONG WHERE TITLE='The Burn')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Peter Stuart')
,(SELECT INSTRUMENT_ID FROM INSTRUMENT
WHERE NAME='Background Vocals'));
INSERT INTO INSTRUMENTATION(SONG_ID,GUESTARTIST_ID,INSTRUMENT_ID) VALUES((SELECT SONG_ID FROM SONG WHERE TITLE='Last Beautiful Girl')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Sam Bacco')
,(SELECT INSTRUMENT_ID FROM INSTRUMENT WHERE NAME='Percussion'));
INSERT INTO INSTRUMENTATION
(COMMENT_TEXT,SONG_ID,GUESTARTIST_ID,INSTRUMENT_ID)
VALUES('This song would not have happened without Tony'
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Tony Adams')
,(SELECT INSTRUMENT_ID FROM INSTRUMENT WHERE NAME='Drums'));
INSERT INTO INSTRUMENTATION
(COMMENT_TEXT,SONG_ID,GUESTARTIST_ID,INSTRUMENT_ID)
VALUES('Great guitar solo'
,(SELECT SONG_ID FROM SONG WHERE TITLE='Stop')
,(SELECT ARTIST_ID FROM ARTIST WHERE NAME='Paul Doucette')
,(SELECT INSTRUMENT_ID FROM INSTRUMENT WHERE NAME='Acoustic Guitar'));
COMMIT;
SPOOL OFF;