SOURCE CODE
DROP TABLE movie;
CREATE
TABLE movie
(
movie_id NUMBER
(5) PRIMARY KEY,
title VARCHAR2
(45) NOT NULL,
description VARCHAR2
(250) NOT NULL,
released_by NUMBER
(3) NOT NULL,
released_on DATE NOT NULL
);
BEGIN
INSERT INTO movie (movie_id,
title,
description,
released_by,
released_on)
VALUES (
'1',
'Edge of Tomorrow',
'Lieutenant Colonel Bill Cage is a
skilled tactician who has honed his abilities through his experiences as a
soldier. However, there is still much he can learn, and soon he is going to get
his chance.',
'1',
'07-OCT-2014');
INSERT INTO movie (movie_id,
title,
description,
released_by,
released_on)
VALUES (
'2',
'Captain America: Winter Soldier',
'Steve Rogers is finding it difficult to
adjust to living life in the contemporary world. He is working for S.H.I.E.L.D.
and begins to suspect a mystery is brewing there.',
'2',
'09-SEP-2014');
INSERT INTO movie (movie_id,
title,
description,
released_by,
released_on)
VALUES (
'3',
'Fed Up',
'America’s problem with obesity is caused
by our inactivity. Or is it? Katie Couric and Stephanie Soechtig tempt us to
restructure our beliefs about the American diet, through this thought-provoking
expose.',
'3',
'09-SEP-2014');
INSERT INTO movie (movie_id,
title,
description,
released_by,
released_on)
VALUES (
'4',
'Godzilla',
'The legendary tale of Godzilla comes
roaring back to life. This time, it's the modern era, and Godzilla is a giant lizard who has been
made fearsome through the interference of radiation.',
'1',
'16-SEP-2014');
INSERT INTO movie
(movie_id,
title,
description,
released_by,
released_on)
VALUES (
'5',
'Neighbors',
'New parents Mac and Kelly settle into domesticity in a quiet neighborhood. The tranquility they have been afforded ceases to exist when a fraternity moves into the house next door.',
'2',
'14-SEP-2014');
COMMIT;
END;
ERROR
Cause: A quoted string must be terminated with a single quote mark (').
Action: Insert the closing quote and retry the statement.