Martin Giffy D'SouzaProtalkapex.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·294 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·28 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 likes·40 readsSQL
