Tag Archives: Sequence

Data Migration : Recreate Sequence in PostgreSQL from Oracle

Posted on September 15, 2019 by Deepak Mahto

As part of Database migrations, we come across lots of cases ranging from mapping between data types support for constraint and a lot. With current blog, we will try to explore on how to take care of Sequence while migration … Continue reading →

Rate this:

Posted in AWS - Database, Oracle to PG migration | Tagged , , , | Leave a comment

Sequence insight

Posted on January 6, 2015 by Deepak Mahto

ORA-02287 Sequence fit into many business requirement where we need to implement incremental logic for a integer column value. Using two pseudo columns, we increment and fetches sequence values. NEXTVAL – Increment sequence value CURRVAL – Reuse current incremented value … Continue reading →

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment