Consider the following schema in SQL:1999.

CREATE TABLE Warehouse (

Address ROW(Street CHAR(20), ZIP CHAR(5)),

Company CompanyType )

CREATE TYPE CompanyType (

Name CHAR(20),

Phone CHAR(10) )

Insert a tuple into Warehouse, for the company Acme, Inc., which has a phone number
6311237654 and whose warehouse is located on Main St. at ZIP code 44744.

Solution:

INSERT INTO Warehouse

VALUES (

ROW ( 'Main St.', 44744 ),

new CompanyType()

. Name('Acme Inc.')

. Phone('6311237654')

)