10.4. Creating Sequences and Synonyms
Various other database objects are needed to support the main objects in the database (such as tables). Two such objects are sequences and synonyms.
10.4.1. Sequences
An Oracle sequence is a named sequential number generator. A sequence is often used to generate a unique key for the primary key of a table. A sequence object is owned by a single schema, but it can be used by other database users if the proper permissions are granted to the users.
sequence
A database structure that generates a series of numbers typically used to assign primary key values to database tables.
Sequences can begin and end with any value, can be ascending or descending, and can skip (increment) a specified number between each ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
