create a sequence in oracle sql

The solution for this is noted below

create a sequence in oracle sql

Solution

# Sequence Syntax:
CREATE SEQUENCE sequence_name
  [INCREMENT BY increment_value]
  [START WITH start_value]
  [MAXVALUE max_value | NOMAXVALUE]
  [MINVALUE min_value | NOMINVALUE]
  [CYCLE | NOCYCLE]
  [CACHE cache_size | NOCACHE]
  [ORDER | NOORDER];

# Usage Example:
CREATE SEQUENCE customer_id_seq
  INCREMENT BY 1
  START WITH 1000
  MAXVALUE 9999
  NOCYCLE
  CACHE 50
  ORDER;

Try other methods by searching on the site. That is if this doesn’t work