Amit Singh
Total Post:562
Points:2810
HOW TO CREATE SEQUENCE IN ORACLE?
© Copyright © 2010 - 2018 MindStick Software Pvt. Ltd. All Rights Reserved
Post:562
Points:2810How 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;