modify

how to reset sequences in oracle

0:00
↔️ ↕️

Timecodes:

hello and welcome to this video and

decision I want to show you how to reset

sequence in Oracle without recreating it

so let's get started

so I'm using an oracle 12 database and

the approach we will take here is is the

same as for example in square server so

you can do the same Approach at first

let's check whether we have sequences

so we don't have any sequence let's

create one

the sequence has been created we can

check that here

and here you have other information like

the last number we can use the sequence

like this

and we can consume values from this

sequence and let's consume for example

thousands values artificially using this

script

and you see at this way we have consumed


Related queries:


how to update sequence value in oracle
how to set sequence value in oracle
how to increment sequence value in oracle
how to reset sequence value in oracle
how to change sequence value in oracle
how to alter sequence value in oracle
how to alter sequence start value in oracle
how to alter sequence max value in oracle
how to change sequence max value in oracle
how to reset sequence next value in oracle
how to update sequence max value in oracle
how to alter sequence current value in oracle
how to change sequence last value in oracle
how to reset sequence current value in oracle
how to set sequence as default value in oracle