1 Create a table named VACATIONUNIT The table has the same s

1) Create a table named VACATION_UNIT. The table has the same structure as the CONDO_UNIT table shown in Figure 3-40 except the CONDOID, LOCATION NUM, and CONDO_FEE columns should use the NUMBER data type. Execute the command to describe the layout and characteristics ot the VACATIONJJNIT table.
2) Add the following record to the VACATION_UNIT table: condo ID: 20; location number: 2; unit number: A04; square feet: 1680; bedrooms: 3; bathrooms: 3; condo fee: 775; and owner number: BL720. Display the conlenfs of the VACATION_UNIT table.
3) Delete the VACATION_UNIT table.

Solution

bathrooms number,

owner number varchar,

square feet number

unit number varchar,

2)

INSERT INTO VACATION_UNIT(condo ID, location number, unit number, square feet, bedrooms, condo fee, owner number)

VALUES (20, 2, A04, 1680, 3, 3, 775, BL720)

To display the inserted contents in the table

SELECT (*) FROM VACATION_UNIT WHERE 1

3)

DELETE (*) FROM VACATION_UNIT WHERE 1

or

DROP table VACATION_UNIT