oracle alter sequence cache size

Solutions on MaxInterview for oracle alter sequence cache size by the best coders in the world

showing results for - "oracle alter sequence cache size"
Gaia
10 Apr 2018
1ALTER SEQUENCE seq_name INCREMENT BY 2;
2ALTER SEQUENCE seq_name MAXVALUE 1000;
3ALTER SEQUENCE seq_name NOMAXVALUE;
4ALTER SEQUENCE seq_name MINVALUE 10;
5ALTER SEQUENCE seq_name NOMINVALUE;
6ALTER SEQUENCE seq_name CACHE 1000;
7ALTER SEQUENCE seq_name NOCACHE;
8ALTER SEQUENCE seq_name CYCLE;
9ALTER SEQUENCE seq_name NOCYCLE;