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

pg

  1. Home>
  2. Blogs>
  3. pg

Deep dive into NULL in PostgreSQL and ways to handle

  • Post author:Admin
  • Post published:October 10, 2020
  • Post category:Database/DB Migration/PostgreSQL
  • Post comments:0 Comments

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 Reading Deep dive into NULL in PostgreSQL and ways to handle

String concatenation using pipe “||” operator in PostgreSQL

  • Post author:Admin
  • Post published:October 10, 2020
  • Post category:Database/PostgreSQL
  • Post comments:0 Comments

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 Reading String concatenation using pipe “||” operator in PostgreSQL

PostgreSQL generate_series() function examples for random data generation

  • Post author:Admin
  • Post published:July 10, 2020
  • Post category:Database/PostgreSQL
  • Post comments:0 Comments

Generating massive amounts of data can be useful to test queries, indexes and tuning complex SQL queries on more realistic volumes, to get useful approximations of production like environment. This…

Continue Reading PostgreSQL generate_series() function examples for random data generation

RAISE Statement in PostgreSQL to debug your query messages

  • Post author:Admin
  • Post published:February 27, 2020
  • Post category:Database/DB Migration/PostgreSQL
  • Post comments:0 Comments

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 Reading RAISE Statement in PostgreSQL to debug your query messages

NULL in Oracle vs. NULL in PostgreSQL

  • Post author:Admin
  • Post published:January 23, 2020
  • Post category:Database/DB Migration/Oracle/PostgreSQL
  • Post comments:0 Comments

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 Reading NULL in Oracle vs. NULL in PostgreSQL

Validating database objects after migration from Oracle to PostreSQL

  • Post author:developer
  • Post published:January 21, 2020
  • Post category:Database/DB Migration/Oracle/PostgreSQL
  • Post comments:2 Comments

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 Reading Validating database objects after migration from Oracle to PostreSQL

Search Our Documentation

Search for:

Popular Database Posts

  • Deep dive into NULL in PostgreSQL and ways to handle
  • String concatenation using pipe “||” operator in PostgreSQL
  • PostgreSQL generate_series() function examples for random data generation
  • CONNECT BY and WITH Recursive queries in Oracle
  • RAISE Statement in PostgreSQL to debug your query messages
  • NULL in Oracle vs. NULL in PostgreSQL

Recent Posts

  • Learn All About Designer Stacked Wedding Rings January 22, 2021
  • Why So Many Restaurants Depend on Metal Utility Carts January 22, 2021
  • Why Olympic Wire Shelving is a Hospitality Industry Must January 22, 2021
  • Deep dive into NULL in PostgreSQL and ways to handle October 10, 2020
  • String concatenation using pipe “||” operator in PostgreSQL October 10, 2020
  • 5 Easy Steps to Make your WordPress Content go Viral September 12, 2020
  • PostgreSQL generate_series() function examples for random data generation July 10, 2020
  • CONNECT BY and WITH Recursive queries in Oracle June 6, 2020

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

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.

Login

Continue with Google

Forgot Password?

Create a new account