What you Need to Know About APEX Validations
Matt Mulvaney, Explorer
Declarative validations in APEX are sublime – easy to implement - not only can they protect your data but they can also provide a level of security at the server level. From APEX 5.1 right up to 18.2, there has been advancements in how pages are submitted which increases usability – but extra levels can be placed at a client level to also enhance your users experience. I’ll show you why Client validations are a good idea and suggest examples how they could be a bad idea. I will also educate the vulnerabilities using Client validations along and how you can secure your APEX page. Extending further in to available validations of the Interactive Grid; Validations is one such option where validations can be places at a grid level in almost identical way to an APEX form. However we can harness our knowledge of the grid to enforce client validations at Interactive Grid row level. I will explain what validations are available at grid level, at model level and at row level and touch on aspects of security. You can use the content of this presentation immediately in your applications.
Matt is an experienced APEX solution designer having designed numerous complex systems using a broad range of Oracle Technologies. Building on his previous experience of Oracle Forms & PL/SQL, he is entirely focused on providing functionally rich APEX solutions. Matt is an Oracle ACE and promotes APEX as a software platform and openly shares best practises, techniques & approaches. Matt has a passion for excellence and enjoys producing high quality software solutions which provide a real business benefit.