This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Matt Mulvaney

What you Need to Know About APEX Validations 


Matt Mulvaney, Explorer


 

Abstract

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.  

Speaker Biography

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.