Day 11 — SAP HANA Sequences

What is a Sequence in SAP HANA? Why do we use it?

A Sequence is a database object that automatically generates unique numbers. 1. What is a Sequence? a. Generates unique numbers. b. Automatically increments values. c. Prevents duplicate IDs. d. Used for Primary Keys. e. Managed by the database. 2. Why Do We Use Sequences? a. Creates unique Order IDs. b. Creates Invoice Numbers. c. Creates Employee IDs. d. Avoids manual numbering. e. Ensures data consistency. 3. Advantages of Sequences a. Automatic number generation. b. No duplicate values. c. Easy to maintain. d. Faster than manual ID generation. e. Supports multiple users simultaneously.

• An online shopping website receives 1,000 orders. • A Sequence automatically generates: • ORD10001 • ORD10002 • ORD10003 • Every Order ID is unique. • No duplicate Order IDs are created.

1. What is a Sequence? 2. Why do we use Sequences? 3. Where are Sequences used? 4. Can a Sequence generate duplicate numbers? 5. Give one real-time example.