sequence.nextval check

[snoopyhzy]

https://stackoverflow.com/questions/7810108/sequence-and-case-in-a-select-in-oracle

do not use sequence.nextval in decode or case when it may be return the result that you are expected