Chapter 6, Problem 1HOA

Explanation of Solution

Creating a SEQUENCE:

The database object that is used to generate series of integers is termed as SEQUENCE. These integers in the database are mostly used to generate primary key that are unique for each record in a table or for internal control purposes.

Syntax:

CREATE SEQUENCE sequenceName

[INCREMENT BY value]

[START WITH value]

[{MAXVALUE value | NOMAXVALUE}]

[{MINVALUE value | NOMINVALUE}]

[{CYCLE | NOCYCLE}]

[{ORDER | NOORDER}]

[{CACHE value | NOCACHE}];

• The commands that are given in square brackets are optional.
• The commands given in curly brackets indicate that one of the two options can be used, but not both.
• INCREMENT BY specifies the interval between two sequential values.
• START WITH clause establishes the starting value for the sequence.
• MAXVALUE and MINVALUE clauses establish a minimum or maximum value for the sequence...