Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Mar 12th, 2013  |  syntax: None  |  size: 1.06 KB  |  views: 374  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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.
clone this paste RAW Paste Data