Oracle REGEXP_LIKE function
- 27 October 2022
- Database Performance ManagementTechnology Business
Oracle REGEXP_LIKE function allows regular expressions in the WHERE sentence in SELECT, INSERT, UPDATE or DELETE queries….
Oracle REGEXP_SUBSTR function
- 25 October 2022
- Database Performance ManagementTechnology Business
The Oracle/PLSQL REGEXP_SUBSTR function is an extension of function SUBSTR. This function, represented in Oracle 10g, allows you to extract substring …
NOTIFY/LISTEN: POSTGRESQL AUTOMATIC CLIENT NOTIFICATION
Users can listen in on database activity using the LISTEN/NOTIFY capability. It is still one of PostgreSQL’s most used features despite being one of t…
Oracle REPLACE function.
- 24 October 2022
- Deep learningSoftware EngineeringTechnology Business
The Oracle/PLSQL REPLACE function replaces a sequence of characters in a string with another character set….
Why are my postgresql update times getting less timely?
A customer recently questioned me about why a bulk load into a PostgreSQL table continued slowing down over time. They saw that the trigger on the tab…
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!