Data Manipulation Language (DML)
Duration: 10 to 15 minutes.
- 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.
- Change this location address to include "Ave" rather than "Avenue"
- Delete this address based upon its primary key.
- Rollback the changes.
--Columns omitted for brevity...
INSERT INTO locations VALUES (999, '600 Forbes Avenue', '15282',
UPDATE locations SET street_address = replace(street_address,
WHERE location_id = 999;
DELETE FROM locations