Oracle EMPTY_CLOB function
- 16 November 2022
- Machine learningTechnology Business
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…
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….
Large database size Distribution MS SQL Server
- 14 November 2022
- Database Performance ManagementMachine learning
Sometimes you have to face the situation when in Microsoft SQL Server with the configured replication, the database distribution starts to grow. There…
Oracle NULLIF function
Oracle/PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the function NULLIF returns NULL. Otherwise, it returns expr1….
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!