Question: what is difference between cycle and nocycle option in sequence?
Answer: The cycle option will end up with error if you are using this sequence for the primary key values as it won't allow the duplicates. The oracle sequence by default creates with nocycle option. The nocycle option will give you an error message when you try to fetch next value after reaching the max value.