Migrating Cursors from Oracle to PostgreSQL
Cursor is a mechanism by which you can assign a name to a SELECT statement and manipulate the information within that SQL statement. A cursor is a pointer to the…
Cursor is a mechanism by which you can assign a name to a SELECT statement and manipulate the information within that SQL statement. A cursor is a pointer to the…
PostgreSQL database treats NULL as unknown. NULL is not same as empty or zero value. This is why you can not compare NULL with anything in PostgreSQL database. Comparison of…
Database migration is conceptually though a simple task, but there are many uninvited challenges that database migration brings in. You can read our article Challenges during a typical data migration…
PostgreSQL supports pipe "||" operator which is also called as string concatenation operator. PostgreSQL database also has CONCAT function to perform string concatenation. postgres=# SELECT 'This'||' is string'||' concat'||' example'…
RAISE statement in PostgreSQL is used to report messages and raise errors. PostgreSQL provides level option to specify with RAISE that specifies the severity of the statement. Possible levels with…
Managing databases to run at scale with high availability and reliability is difficult, time consuming and expensive. This is why, many companies are moving their databases to cloud to explore…