---
title: "How to create sequence in oracle?"  
description: "How to create sequence in oracle?"  
author: "Amit Singh"  
published: 2011-08-12  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/1143/how-to-create-sequence-in-oracle  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to create sequence in oracle?

A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.

The syntax for a sequence is:

CREATE SEQUENCE sequence_name\
MINVALUE value\
MAXVALUE value\
START WITH value\
INCREMENT BY value\
CACHE value;

## Answers

### Answer by Amit Singh

A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.

The syntax for a sequence is:

CREATE SEQUENCE sequence_name\
MINVALUE value\
MAXVALUE value\
START WITH value\
INCREMENT BY value\
CACHE value;


---

Original Source: https://www.mindstick.com/interview/1143/how-to-create-sequence-in-oracle

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.