Write a script that uses an anonymous block to include two SQL statements coded as a transaction…

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.


Order a Similar Paper Order a Different Paper

1.Write a script that uses an anonymous block to include two SQL statements coded as a transaction to delete the row with a customer ID of 8 from the Customers table. To do this, you must first delete all addresses for that order from the Addresses table.

If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

2. Write a script that uses an anonymous block that includes these statements coded as a transaction:

— hard-code the id values for orders and order_items

INSERT INTO orders VALUES

(DEFAULT, 3, NOW(), ‘10.00’, ‘0.00’, NULL, 4,

‘American Express’, ‘378282246310005’, ’04/2013′, 4);

INSERT INTO order_items VALUES

(DEFAULT, order_id, 6, ‘415.00’, ‘161.85’, 1);

INSERT INTO order_items VALUES

(DEFAULT, order_id, 1, ‘699.00’, ‘209.70’, 1);

If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper