Skip to content
DCodeMan
  • Home
  • Resources
    • Documentation
      • Oracle SQL
      • Oracle PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login
  • Home
  • Resources
    • Documentation
      • Oracle SQL
      • Oracle PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login

Migrating Cursors from Oracle to PostgreSQL

  • Post published:September 25, 2021
  • Post category:Database/DB Migration

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…

Continue ReadingMigrating Cursors from Oracle to PostgreSQL

Deep dive into NULL and Empty string in PostgreSQL

  • Post published:March 10, 2021
  • Post category:Database/DB Migration/PostgreSQL

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…

Continue ReadingDeep dive into NULL and Empty string in PostgreSQL

NULL in Oracle vs. NULL in PostgreSQL

  • Post published:February 23, 2021
  • Post category:Database/DB Migration/Oracle/PostgreSQL

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…

Continue ReadingNULL in Oracle vs. NULL in PostgreSQL

String concatenation using pipe “||” operator in PostgreSQL

  • Post published:October 10, 2020
  • Post category:Database/PostgreSQL

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'…

Continue ReadingString concatenation using pipe “||” operator in PostgreSQL

RAISE Statement in PostgreSQL to debug your query messages

  • Post published:February 27, 2020
  • Post category:Database/DB Migration/PostgreSQL

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…

Continue ReadingRAISE Statement in PostgreSQL to debug your query messages

Validating database objects after migration from Oracle to PostreSQL

  • Post published:January 21, 2020
  • Post category:Database/DB Migration/Oracle/PostgreSQL

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…

Continue ReadingValidating database objects after migration from Oracle to PostreSQL

Recent Posts

  • Working with Hash partitions in PostgreSQL June 15, 2022
  • Escape Single Quotes in Oracle SQL April 22, 2022
  • Migrating Cursors from Oracle to PostgreSQL September 25, 2021
  • Difference between single quote and double quote in Oracle SQL September 1, 2021
  • Deep dive into NULL and Empty string in PostgreSQL March 10, 2021
  • NULL in Oracle vs. NULL in PostgreSQL February 23, 2021
  • Learn All About Designer Stacked Wedding Rings January 22, 2021
  • Why So Many Restaurants Depend on Metal Utility Carts January 22, 2021

Search Our Documentation

Search for:

Oracle Interview Q&A

Oracle SQL Q&A
  • Oracle SQL Interview Questions
  • Oracle SQL Practice Questions – Article1
  • Oracle SQL Practice Questions – Article2
  • Oracle SQL Practice Questions – Article3
  • Oracle SQL Logical Questions
Oracle PL/SQL Q&A
  • Oracle PL/SQL Basic Interview Questions
  • Oracle PL/SQL Stored Procedures Interview Questions
  • Oracle PL/SQL Exception Handling Interview Questions
  • Oracle PL/SQL Trigger Interview Questions

Sign-in

Sign up
Forgot your password?

Categories

  • Business (2)
  • Database (18)
    • Oracle (5)
    • PostgreSQL (8)
  • DB Migration (8)
  • Hospitality (3)
  • Other (1)
  • Technology (4)

DCODEMAN

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of use

Resource Hub

  • Q & A
  • Documentation
  • Blogs
  • Courses

What’s Fascinating!

  • Donate
  • Oracle SQL Q&A
  • Oracle PL/SQL Q&A
  • Interesting Facts

Share

Copyright © 2020 DCODEMAN, All rights reserved.