Database Multilingual Engine (MLE) hands-on Posted on September 30, 2023 , Modified on January 12, 2026 , by Yannick JaquierTable of contents Preamble Multilingual Engine (MLE) testing Multilingual Engine (MLE) advanced testing References Read more Oracle SQL Leave a comment
Edition-Based Redefinition (EBR) for online application migration Posted on June 20, 2023 , Modified on June 20, 2023 , by Yannick JaquierTable of contents Preamble Edition-Based Redefinition (EBR) and DBMS_REDEFINITION test case Edition-Based Redefinition (EBR) testing Application preparation for EBR Creating the new edition and new edition objects Testing the new edition and crossedition triggers Using service to point to desired edition DBMS_REDEFINITION for online table redefinition References Read more Oracle DBMS_REDEFINITION, Edition-Based Redefinition (EBR), SQL Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
Polymorphic Table Functions (PTF) hands-on Posted on April 20, 2023 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Polymorphic Table Functions (PTF) basic example Polymorphic Table Functions (PTF) manipulating output Polymorphic Table Functions (PTF) debugging References Read more Oracle Polymorphic Table Functions (PTF), SQL Leave a comment
Table and scalar SQL macros hands-on Posted on March 3, 2023 , Modified on March 20, 2023 , by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Read more Oracle Development, SQL Leave a comment
ORC versus Parquet compression and response time Posted on August 2, 2019 , Modified on June 10, 2026 , by Yannick JaquierTable of contents Preamble ORC versus Parquet compression ORC versus Parquet response time References Read more Hadoop SQL, Tuning Leave a comment