Infrastructure at your Service

SQL Archives - Blog dbi services

Stéphane Haby

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

By | Database Administration & Monitoring, Development & Performance, Technology Survey | 4 Comments

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I will show you what is TRIM. This function is a replacement of RTRIM and LTRIM to delete all space character…

 
Read More
Morgan Patou

Documentum – DFC traces setup & investigation

By | Application integration & Middleware, Entreprise content management | No Comments

When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are the limitations of such things. Enabling the DFC traces can be done very easily by updating the dfc.properties file of…

 
Read More
Alain Lacour

APEX Connect 2017 – Day 1

By | Development & Performance | No Comments

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by Bryn Llewellyn I decided to attend presentations on following topics: – Temporal Validity and Flashback Data Archive – Universal Theme and Custom Themes in APEX 5.1 – Using REST Services in APEX applications the nice way…

 
Read More
Daniel Westermann

How to destroy your performance: PL/SQL vs SQL

By | Database Administration & Monitoring | No Comments

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing it in PL/SQL. This was a very good example for myself to remind me to check the documentation and to verify if what I believed a feature does is really what the feature is actually…

 
Read More
Franck Pachot

Oracle 12cR2 SQL new feature: LISTAGG overflow

By | Database Administration & Monitoring | No Comments

LISTAGG was a great feature introduced in 11g: put rows into line with a simple aggregate function. 12cR2 adds an overflow clause to it. What happens when you have so many rows that the LISTAGG result is too long? SQL> select listagg(rownum,’,’)within group(order by rownum) from xmltable(‘1 to 10000′); select listagg(rownum,’,’)within group(order by rownum) from xmltable(‘1 to 10000′) * ERROR at line 1: ORA-01489: result of string concatenation is too long An error at runtime,…

 
Read More
Alain Lacour

APEX Connect 2016 – Day 1 – SQL and PL/SQL

By | Development & Performance | No Comments

This year the APEX connect conference spans over three days with the first day dedicated to SQL and PL/SQL which are the basement of APEX and its close link to the Database. After the Keynote about “Six months of ask Tom” by Chris Saxon who is filling in for Tom Kyte on the famous “Ask Tom” website I decided to attend presentations on following topics: – A Primer on Service Workers – Managing the changes…

 
Read More