71. Write the SQL command to save the changes made to the PRICE and MOVIE tables

Question

71. Write the SQL command to save the changes made to the PRICE and MOVIE tables in Problems 68- 70.

Probelms 68-70 are:

68. Write the SQL command to change the movie year for movie number 1245 to 2010.

UPDATE Movie SET MOVIE_YEAR = 2008 WHERE MOVIE_NUM = 1245;

69. Write the SQL command to change the price code for all action movies to price code 3.

UPDATE Movie SET PRICE_CODE = 3 WHERE MOVIE_GENRE = ‘Action’;

70. Write a single SQL command to increase all price rental fee values by $0.50.

UPDATE Price SET PRICE_CODE = PRICE_CODE + ‘0.50’;

please and thank you!

Explanation / Answer

Answer is COMMIT;

The COMMIT command executes a SQL COMMIT statement. When you want changes that you have made in an analytic workspace to be committed when you execute the COMMIT command, then you must first update the workspace using an UPDATE statement. UPDATE moves changes from a temporary work area to the database table in which the workspace is stored. Changes that have not been moved to the table are not committed. When you do not use UPDATE and COMMIT statements, changes made to an analytic workspace during your session are discarded when you end your Oracle session.

When you execute a SQL COMMIT statement in your database session, all changes made in your session (including all updated changes in workspaces that you have attached with read/write access) are committed. All committed changes are visible to other users who subsequently attach the workspace. However, another user's UPDATE and COMMIT statements do not affect your view of an already attached workspace.

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.