To V or not to V? or.. using SQL Macros in APEX?
Track
APEX
Datum i vrijeme
četvrtak, 14. listopad 2021., 10:20
Dvorana
Dvorana B
Trajanje
45'
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. In this session I will give you an overview of this new functionality and how you can use it in your APEX applications.
Detalji o predavanju
O predavaču
Alex Nuijten, autor
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, nlOUG 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.
Najbolji pokrovitelj
Edukacijski pokrovitelj
Medijski pokrovitelj
HrOUG.hr
Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.