Data Manipulation Language (DML) - Exercise

Contact Us or call 1-877-932-8228
Data Manipulation Language (DML) - Exercise

Data Manipulation Language (DML)

Duration: 10 to 15 minutes.
  1. Add a new location with a primary key identifier of 999, an address of 600 Forbes Avenue in Pittsburgh PA (in the US) with a zip code of 15282.
  2. Change this location address to include "Ave" rather than "Avenue"
  3. Delete this address based upon its primary key.
  4. Rollback the changes.


--Columns omitted for brevity...
INSERT INTO locations VALUES (999, '600 Forbes Avenue', '15282', 
	'Pittsburgh', 'PA','US');

UPDATE locations SET street_address = replace(street_address,
	'Avenue', 'Ave') 
WHERE location_id = 999;

DELETE FROM locations 
WHERE location_id=999;