Oracle NVL2 function
- 12 November 2022
- Database Performance ManagementSoftware Engineering
Oracle/PLSQL NVL2 function extends the functionality of the NVL function. It replaces the value when a Null value is encountered and also when a non-N…
POSTGRESQL V14’S BETTER SQL FUNCTIONS
- 9 November 2022
- Database Performance ManagementTechnology Business
Let’s create a simple example of an SQL function with the “classical” syntax so that we have some material for demonstrations:
CREATE EXTENSION unacc…
PSQL POSTGRESQL POWERUSER PRACTICE: GEXEC
Automating routine tasks is becoming more and more important for PostgreSQL power users, and gexec can help. This article will demonstrate how to use …
10 simple steps to a full understanding of SQL
Very many programmers look at SQL like a terrible beast. SQL – one of the few declarative languages, and its behavior is fundamentally different from …
Oracle SQLERRM function
The SQLERRM function returns an error message related to an exceptional situation. This function can only be used in the exception handling section of…
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!