1. Create a sequence for populating the Customer# column of the CUSTOMERS table.

Question

1. Create a sequence for populating the Customer# column of the CUSTOMERS table. When
setting the start and increment values, keep in mind that data already exists in this table. The
options should be set to not cycle the values and not cache any values, and no minimum
or maximum values should be declared.
2. Add a new customer row by using the sequence created in Question 1. The only data currently
available for the customer is as follows: last name = Shoulders, first name = Frank, and
zip = 23567.

I have question 1. I just need how to add on question 2

Explanation / Answer

Create a sequence for populating the Customer# column of the CUSTOMERS table. When
setting the start and increment values, keep in mind that data already exists in this table. The
options should be set to not cycle the values and not cache any values, and no minimum
or maximum values should be declared.

ans:

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.