Oracle NULLIF function
- 14 November 2022
- Machine learningSoftware Engineering
Oracle/PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the function NULLIF returns NULL. Otherwise, it returns expr1….
Oracle NVL function
- 13 November 2022
- Database Performance ManagementTechnology Business
Oracle/PLSQL NVL function allows you to replace the value when there is a Null value….
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…
Oracle SQLCODE function
- 12 November 2022
- Database Performance ManagementMachine learning
The SQLCODE function returns the error number associated with an exceptional situation. This function can only be used in the exception handling secti…
Oracle NVL2 function
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…
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!