Question

write the SQL command to save the rows inserted in problem 97

Answer 1

Answer:

INSERT INTO RENTAL VALUES (1008, '03-MAR-11', 105);

INSERT INTO RENTAL VALUES (1009, '03-MAR-11', 111);

DETAILRENTAL:

INSERT INTO DETAILRENTAL VALUES (1001, 34342, 2, '04-MAR-11', '02-MAR-09', 1);

INSERT INTO DETAILRENTAL VALUES (1001, 34366, 3.5, '04-MAR-11', '02-MAR-09', 3);

INSERT INTO DETAILRENTAL VALUES (1001, 61353, 2, '04-MAR-11', '03-MAR-09', 1);

INSERT INTO DETAILRENTAL VALUES (1002, 59237, 3.5, '04-MAR-11', '04-MAR-09', 3);

INSERT INTO DETAILRENTAL VALUES (1003, 54325, 3.5, '04-MAR-11', '09-MAR-09', 3);

INSERT INTO DETAILRENTAL VALUES (1003, 61369, 2, '06-MAR-11', '09-MAR-09', 1);

INSERT INTO DETAILRENTAL VALUES (1003, 61388, 0, '06-MAR-11',

Explanation: