How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 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 Continue reading
Polymorphic Table Functions (PTF) hands-on Posted on April 20, 2023, updated on April 20, 2023 by Yannick JaquierTable of contents Preamble Polymorphic Table Functions (PTF) basic example Polymorphic Table Functions (PTF) manipulating output Polymorphic Table Functions (PTF) debugging References Continue reading
Table and scalar SQL macros hands-on Posted on March 3, 2023, updated on March 20, 2023 by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Continue reading
ORC versus Parquet compression and response time Posted on August 2, 2019, updated on February 20, 2020 by Yannick JaquierTable of contents Preamble ORC versus Parquet compression ORC versus Parquet response time References Continue reading
Jupyter Lab installation on Fedora to access an Oracle database Posted on February 14, 2019, updated on October 28, 2019 by Yannick JaquierTable of contents Preamble Python 3.7 installation Jupyter Lab installation Jupyter Lab testing References Continue reading
Minimum required privileges for PL/SQL debugging with SQL Developer Posted on January 16, 2019, updated on January 16, 2019 by Yannick JaquierTable of contents Preamble PL/SQL debugging as object owner PL/SQL debugging with another account References Continue reading