ARTIST.Name Artist.Nationality Transaction.purchaseDate Transaction.SalesPrice..

Question

ARTIST.Name
Artist.Nationality
   Transaction.purchaseDate
   Transaction.SalesPrice...
       Customer.Name
       Customer.Phone.AreaCose
       Customer.Phone.LocalNumber
   Customer.Name...

(The Ellipses(...) refer to the structures that can repeat.


Code SQL statements to update this view as follows:
a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby.
b. Create a new transaction for Mark Toby. Assume you have thenecessary transaction, work, and customer data in a structure namedNewTrans.
c. Add new interested customers for Mark Toby. Assume they arestored in a collection that you can access with the command ForEach NewCust.Name?

Thanks a bunch. let me know if you need more information.

Explanation / Answer

Dear User, a) SQL> Update    ARTIST
          Set         name = 'MarkToby'
          Where   name = 'Mark Tobey'; ITS HELPFUL TO YOU......

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---