Answer to Question #63223 in Databases | SQL | Oracle | MS Access for jonney

Question

by oracle sql*plus
1- Creating Sequences.
a. Connect as the DBA. Create a sequence named VENDOR_SEQUENCE that starts with the value 1 and is incremented by 1. Set the values for MINVALUE = 1 and MAXVALUE = 99999. Allow the sequence to CYCLE automatically and allocate NOCACHE as a sequence option.
b. Attempt to SELECT a value from the VENDOR_SEQUENCE by using the DUAL table in your SELECT command.

Answer 1

a) create sequence VENDOR_SEQUENCE start with 1 increment by 1 minvalue 1 maxvalue 99999 cycle nocache;
b) select VENDOR_SEQUENCE.NEXTVAL from dual;