</>
sqlbeginner

Sequence - Technique 10

Create and use sequences

sql
CREATE SEQUENCE IF NOT EXISTS invoice_number_seq START 1000;

INSERT INTO invoices (invoice_number, customer_id, total)
VALUES (nextval('invoice_number_seq'), 42, 199.99)
RETURNING invoice_number;

Use Cases

  • database operations
  • data management

Tags

#sql#database#sequence

Related Snippets

Similar patterns you can reuse in the same workflow.

sqlbeginner

View - Technique 1

Create and manage database views

Best for: database operations

#sql#database
sqlintermediate

Index - Technique 2

Create and optimize database indexes

Best for: database operations

#sql#database
sqladvanced

Trigger - Technique 3

Create triggers for automatic actions

Best for: database operations

#sql#database
sqlbeginner

Procedure - Technique 4

Create stored procedures

Best for: database operations

#sql#database