序列–索引–同义词.ppt

What Is a Sequence? A sequence is a database object created by a user, and can be shared by multiple users to generate unique integers. You can use the sequences to automatically generate primary key values. A typical usage for sequences is to create a primary key value, which must be unique for each row. The sequence is generated and incremented (or decremented) by an internal Oracle8 routine. This can be a time-saving object because it can reduce the amount of application code needed to write a sequence-generating routine. Sequence numbers are stored and generated independently of tables. Therefore, the same sequence can be used for multiple tables. Creating a Sequence Automatically generate sequential numbers by using the CREATE SEQUENCE statement. In the syntax: sequence is the name of the sequence generator INCREMENT BY n specifies the interval between sequence numbers where n is an integer (If this clause is omitted, the sequence will increment by 1.) START WITH n specifies the first sequence number to be generated (If this clause is omitted, the sequence will start with 1.) MAXVALUE n specifies the maximum value the sequence can generate NOMAXVALUE specifies a maximum value of 10^27 for an ascending sequence and –1 for a descending sequence (This is the default option.) MINVALUE n specifies the minimum sequence value NOMINVALUE specifies a minimum value of 1 for an ascending sequence and – (10^26) for a descending sequence (This is the default option.) CYCLE | NOCYCLE specifies that the sequence continues to generate values after reaching either its maximum or minimum value or does not generate additional values (NOCYCLE is the default option.) CACHE n | NOCACHE specifies how many values the Oracle Server will preallocate and keep in memory (By default, the Oracle Server will cache 20 values.) Creating a Sequence (continued) The example on the slide creates a sequence named DEPT_DEPTNO