POSTGRESQL CASE-INSENSITIVE PATTERN MATCHING
- 19 November 2022
- Machine learningSoftware Engineering
Case-insensitive search is a highly requested feature, in part to keep Microsoft SQL Server compatibility. Using case-insensitive ICU collations is on…
Choose no rules for updated transaction analyses.
- 18 November 2022
- Machine learningOracle
I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction anomalies. This article will talk about wh…
Oracle GROUP_ID function
- 16 November 2022
- Machine learningTechnology Business
Oracle/PLSQL GROUP_ID function assigns a number to each group as a result of GROUP BY operator. GROUP_ID function is most often used to identify dupli…
Oracle EMPTY_CLOB function
Oracle PLSQL EMPTY_CLOB function can be used to initialize empty LOB columns in INSERT or UPDATE operators or it can be used to initialize LOB variabl…
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…
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!