Fraud Blocker

Oracle NANVL function

The Oracle/PLSQL NANVL function allows you to replace a value for a floating point number such as BINARY_FLOAT or BINARY_DOUBLE when Nan (Not a number…

Continue Reading

Oracle LNNVL function

Oracle/PLSQL LNNVL function is used in the WHERE SQL query sentence to evaluate the state when one of the operands may contain the value NULL….

Continue Reading

Large database size Distribution MS SQL Server

Sometimes you have to face the situation when in Microsoft SQL Server with the configured replication, the database distribution starts to grow. There…

Continue Reading

Oracle NVL function

Oracle/PLSQL NVL function allows you to replace the value when there is a Null value….

Continue Reading

It does matter what the column order is in PostgreSQL.

Recently, I came across some really broad tables with hundreds of columns in a database that was not particularly well organized. Our PostgreSQL suppo…

Continue Reading

Thank you, the form has been submitted.