Updating oracle sequence
When the system comes back up, Oracle will cache new numbers from where it left off in the sequence, ignoring the so called "lost" sequence values.
To retrieve the next value in the sequence order, you need to use option specifies how many sequence values will be stored in memory for faster access.
The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost".
You may wish to update records in one table based on values in another table.
Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause.
Check out all our database development sessions at OOW19 Thanks for the question, Robert.