@alexnuijten
Alex Nuijten is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX).
Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards.
He wrote many articles in Oracle related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog “Notes on Oracle” (nuijten.blogspot.com). Alex is co-author of the following books Oracle APEX Best Practices (published by Packt Publishers) and Real World SQL and PL/SQL (published by Oracle Press).
Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.
During Contech2024,Alex Nuijten will present 2 talks: To V or not to V? or.. using SQL Macros in APEX? and Cookie Cutter APEX Applications
| To V or not to V? or.. using SQL Macros in APEX? – Abstract: The V function has been around APEX as long as … let’s say very long and that’s a long time. The V function allows you to reference item values from session state in your SQL statements. When calling V there would always be a price to pay. With recent releases of the database there is a new way to do something similar; SQL Macro. With SQL Macro you can create parameterized views and this could be very interesting for APEX Developers. In this session I will give you an overview of this new functionality and how you can use it in your APEX applications. |
| Cookie Cutter APEX Applications – Abstract In a perfect world your APEX SAAS solution would be deployed with a click of a button, have a separate database for each customer, and can a customer choose when they want to upgrade to the next version. In this perfect world, the customer don’t have to worry about default lookup data, because the SAAS provider does that. This perfect world can be created with Application Containers and Oracle APEX. In this session you will learn the basics of Application Containers, how data is shared and separated in each container and how a new version is rolled out. |