Just submitted first of my two chapters (Tabular Forms) for the new Expert Oracle APEX 2nd Edition. The chapter is covering the most important practices in Tabular Form handling. Also, a couple of neat features like cascading select lists in Tabular Forms - this time using standards only. Still not sure when the book will be published but it should happen soon.
Follow on Twitter
A few years back I pondered whether DISTINCT was a bug.
My premise was that if you are depending on DISTINCT to return a correct result set, something is seriously wrong with your table design. I was reminded of this again recently when I ran across Kent Graziano's post on Better Data Modeling: Are you making these 3 beginner mistakes in your data models?.
Oracle Database 12c introduced Oracle Real Application Security (RAS), the next generation Oracle Virtual Private Database (VPD). In APEX 5.0 RAS is declaratively build-in. Follow the below steps to enable it:
Es tut sich ganz schön was in der APEX Community dieses Jahr. APEX 5.0 wurde veröffentlich. APEX Connect im Juni findet statt und sollte bisher der größte APEX-Treffen im deutschprachigen Raum werden. Nun, wurde auch eine Reihe an Webinaren organisiert - APEX 5.0 Summer School - für alle, die keinen Urlaub machen oder für diejenigen, die den Urlaub langweilig finden.
In June 2012, Scott Spendolini and I signed the papers whereby Enkitec acquired the assets of Sumneva. We announced this big news at ODTUG KSCOPE and it was met with quite a lot of interest and more than a few congratulatory beers. Our goal was to step away from the day-to-day trappings of running your own business (i.e. Accounting, Sales, Paying the electric bill, etc) and focus our core skills in APEX.
Just under three years ago, I joined Enkitec when they acquired Sumneva. The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.
Woo hoo! Oracle Application Express 5.0 has been released. Read all about it here.
In previous blog posts I talked about JSON for APEX Developers:
In this post I want to show how you store and query JSON data straight in the database.