Using SQL complete Exercise 9

a. Wh -SOL for the following triggers en inserting a row in TAL PERSO the RESERVATION table, add the NUM PERSONS value to RESERVATIo value for the appropriate trip between trow in the RESERVATION table, add the difference TOTAL PERSONS value for the appropr the new NUM PERSONS valu NUMPERSONS value and the old NUM_PERSONS value to the ng a row in the RESERVATION table, subtract the NUM PERSONS e TRIP table contains several columns with character data, the staff at Colo- value from the TOTAL PERSONS value for the appropriate tip. 9. Because th nial Adventure Tours would like to know more a nternet to research the following string functions: LENGTH, SUBSTR, and INITCAP. Are bout string or character functions. Use the these functions the same in Oracle, SQL Server, and Access? Write a paragraph that discusses what the functions do and any differences and/or similarities between the func- tions in Oracle, SQL Server, and Access. Then perform the following tasks using Oracle SQL: a. b. Display the first three characters on the left from the TYPE column. Starting at the fourth character from the left, display the next five characters in the START LOCATION column. se the Solmaris Condominium Group database (see Figures 1-9 through 1-13 in Chapter 1) mplete the following exercises. If directed to do so by your instructor, use the information olmaris Condominium Group co h the Chapter 3 Exercises to print your output or save it to a file fau oll owners, The first name should