Sequence Query

[rachelle]

I want to know what happens when a user tries to execute a create sequence statement for an existing sequence. What would be the next value of sequence after the above statement gets executed? Someone kindly provide a brief idea on this.

[sujan kumar]

When you create a sequence,do you refer to any other object?No. you create a sequence by specifying the sequence paramaters,but not based on another sequence.

[anilkumar2010]

When u r create SQUENCE by default SEQUENCE IS created with all default values. when u write a query for executing next value it will be showed as 0