Please use the below query to create sequence in Oracle. Here
MAXVALUE - denotes the maximum value that can be accoomdated
CACHE - number of the values that will be created whenever nextval call is done and then put in cache
START WITH - the value that will begin with
INCREMENT BY - the incremental value
CREATE SEQUENCE <schema_name>.<sequence_name>
MINVALUE 1
MAXVALUE 99999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
ex:
CREATE SEQUENCE TR.TRAVEL_DETAIL_ID_SEQ
MINVALUE 1
MAXVALUE 999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
No comments:
Post a Comment