| A | B |
|---|
| CURRVAL | returns the current sequence value |
| CREATE SEQUENCE | command that automatically generates sequential numbers |
| Sequences | generates a numeric value |
| NO MINVALUE | specifies a minimum value of 1 for an ascending sequence and – (10^26) for a descending sequence (default) |
| NO MAXVALUE | specifies a maximum value of 10^27 for an ascending sequence and - 1 for a descending sequence (default) |
| NEXTVAL | returns the next available sequence value |
| CYCLE/ NOCYCLE | specifies whether the sequence continues to generate values after reaching its maximum or minimum values |
| MAXVALUE | specifies a maximum or default value the sequence can generate |
| CACHE/ NOCACHE | specifies how many values the Server pre-allocates and keeps in memory |
| INCREMENT BY | specifies the interval between sequence numbers |
| MINVALUE | specifies the minimum sequence value |
| STARTS WITH | specifies the first sequence number to be generated |
| DROP INDEX | Removes an index |
| Function-based index | stores the indexed values and uses the index based on a SELECT statement to retrieve the data |
| Synonym | gives alternative names to objects |
| Confirming index | Confirms the existence of indexes from the USER_INDEXES data dictionary view |
| Unique index | The Oracle Server automatically creates this index when you define a column in a table to have a PRIMARY KEY or a UNIQUE KEY constraint |
| Non-unique index | schema object that speeds up retrieval of rows |
| Composite index | an index that you create on multiple columns in a table |
| CREATE PUBLIC SYNONYM | to refer to a table by another name to simplify access |
