Ryan Williamsora-wtf.com·Aug 20, 2024Best Practices for Using utPLSQL for Unit Testing, Documentation, and Reporting in Oracle DatabaseutPLSQL is a powerful unit testing framework for PL/SQL in Oracle databases. It supports a wide range of testing capabilities, including assertions, test suites, code coverage analysis, and more. Below are best practices for using utPLSQL effectively...Discussunit testing
Martin Giffy D'Souzatalkapex.com·Nov 26, 2023Regular expression patterns [[:upper:]] vs [A-Z]Note: the comparisons in this article also applies to [[:lower:]] vs [a-z] regexp patterns. Oracle regular expressions (regexp) support both [[:upper:]] or [A-Z] to find uppercase letters. At first glance they appear the same. Even regex101.com defin...Discuss·585 readsSQL
Arun Mohanforapexvarsityapexvarsity.com·Oct 19, 2023Course objective and course contentWelcome to our SQL and PL/SQL Essentials for APEX Beginners Course! Course Objective The primary objective of this course is to equip you with a fair understanding of SQL and PL/SQL specifically tailored for Oracle APEX. We understand that as beginne...Discuss·38 readsSQL
mauriciogmauriciogcode.hashnode.dev·Jul 10, 2023Exploring PL/SQL Part 2: Loops, Conditions, and Mathematical FunctionsFOR Loop: The FOR loop is a powerful tool in PL/SQL for iterating over a set of values. An interesting clarification is that it's not necessary to declare the iteration variable (i) when using the PLS_INTEGER data type. This is because the PLS_INTEG...Discuss·2 likesSQL
Richard Martensrhjmartens.nl·Jul 9, 2015making https (webservice) requests from PL/SQL without a walletWhile developing the application for my kscope15 presentation I discovered that my Oracle XE database is unable to handle the certificate for Linked-in. This has to do with the algorithm used to sign the Linked-in certificate. Oracle XE 11 has a bug ...DiscussOracle APEXorclapex