SHARE
TWEET

Untitled

a guest Mar 12th, 2013 497 Never
  1. 1. Add a new row to the ORDERS table with the following data: Order# = 1021, Customer# = 1009
  2. OrderDate = July 20, 2009
  3.  
  4. 2. Modify the zip code on order number 1017 to 33222
  5.  
  6. 3. Save changes permanently to database
  7.  
  8. 4. Add a new row to the ORDERS table with the following data: Order# = 1022, Customer# = 2000
  9. order date = august 6, 2009.  Describe error that is raised and what caused it.  Use comments in your
  10. spool file to describe what hpapened.  
  11.  
  12. 5. Add a new row to the ORDERS table with the following data: Order# = 1023 Customer# = 1009.  Describe
  13. the error that is raised and what caused the error.
  14.  
  15. 6. Creat a script using substitution variables that will allow a user to set a new cost amount
  16. for book based on the ISBN.
  17.  
  18. 7. Use this script or run the script and set the following: ISBN = 1059831198 and cost = 20.00
  19.  
  20. 8. Execute a command that will undo the change made in the previous step.
  21.  
  22. 9. Delete order# 1005, you will address both the master order record and related detail records
  23.  
  24. 10. Execute a command that will undo the previous deletion.
RAW Paste Data
Top