POSTGRESQL TIME ZONE MANAGEMENT
- 20 November 2022
- Database Performance ManagementTechnology Business
Time zones are among the least popular topics in computing, right behind character encoding. In addition, PostgreSQL’s implementation of timestamp wit…
MANAGING SQL ADD-ON PROGRAMS
- 18 November 2022
- Database Performance ManagementSoftware Engineering
We all love and hate bonus cards, “Miles & more,” and bonus points at the same time, don’t we? Recently, we encountered an intriguing use case that go…
How to define table size in MS SQL database
- 17 November 2022
- Database Performance ManagementSoftware Engineering
To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps:
1. Connect to a database ser…
Oracle NANVL function
- 15 November 2022
- Database Performance ManagementMachine learning
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…
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….
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!