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
Immutable tables and blockchain tables hands-on Posted on March 28, 2022 , Modified on May 5, 2026 , by Yannick JaquierTable of contents Preamble Immutable tables Blockchain tables Basic testing Signing rows References Read more Oracle Security Leave a comment
Database Resident Connection Pooling (DRCP) hands-on Posted on January 28, 2022 , Modified on January 25, 2022 , by Yannick JaquierTable of contents Preamble Database Resident Connection Pooling creation Database Resident Connection Pooling testing References Read more Oracle Administration, Development Leave a comment
Gradual Database Password Rollover hands-on Posted on December 28, 2021 , Modified on December 14, 2021 , by Yannick JaquierTable of contents Preamble Gradual Database Password Rollover testing Read more Oracle High Availability, Security Leave a comment
Secure Oracle application design and the ANY privileges Posted on November 28, 2021 , Modified on June 4, 2026 , by Yannick JaquierTable of contents Preamble The not so bad solution to avoid CREATE ANY TABLE Oracle proxy user Conclusion References Read more Oracle Security Leave a comment