68 774
Assignments Done
Successfully Done
In January 2019

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

Question #63223
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.
Expert's answer
a) create sequence VENDOR_SEQUENCE start with 1 increment by 1 minvalue 1 maxvalue 99999 cycle nocache;
b) select VENDOR_SEQUENCE.NEXTVAL from dual;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

Privacy policy Terms and Conditions