Enroll in PostgreSQL Courses
Get Started
Use Code 'DBGRP30' for 30% OffCategory
-
Join 155 other subscribers
Top Posts & Pages
Archives
-
Recent Posts
- Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug January 30, 2026
- PostgreSQL Table Rename and Views – An OID Story January 5, 2026
- PostgreSQL Partition Pruning: The Role of Function Volatility November 4, 2025
- Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly September 28, 2025
- PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations September 6, 2025
- PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease May 10, 2025
- Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson November 10, 2024
- PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood. November 2, 2024
- How to Connect to PostgreSQL Database Through AWS SSM Using pgAdmin or DBeaver. September 26, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance. September 23, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger August 31, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation August 27, 2024
-
Enhance your PostgreSQL skills! Master Database Development and Migration with my course. Click here to start!
Tag Archives: ORA-02287
Sequence insight
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