Author Archives

Working with multiple Trees on the same APEX Page (4.2/5.0)

*+-Ever tried to put multiple Trees on the same page in APEX 4.2?Here’s my example:On the left Tree the “Selected Node Link with” is set to hidden item P1_TREE1, on the right Tree the value that sets the tree is set to P1_TREE2. At least it should do that…

APEX 5.0: pimping the Login page

*+-When you create a new application in APEX 5.0, the login page probably looks like this:I love the build-in login page of APEX itself – luckily it’s easy enough to build that in our own apps too. Thank you APEX Dev team!The first step is to change the r…

Loading CSV files with special characters in Oracle DB

*+-I often need to load the data of Excel or CSV files into the Oracle Database.Ever got those annoying question marks when you try to load the data? or instead of question marks you just get empty blanks when the file is using special characters? Here’s …

Oracle Database Tools updated – check out SQLcl

*+-Today Oracle released new versions of:SQL Developer 4.1 EA2SQL Developer Data Modeler 4.1 EA2SQLcl (below SQL Developer downloads)Also Oracle REST Data Services 3 got a new EA2 version.You may want to check Kris Rice’s blog for new features.I already b…

APEX Conferences in 2015

*+-In 2015 most APEX-only conferences are scheduled in history. I definitely recommend to attend at least one of the conferences as it’s a great time to meet other people, industry experts and the APEX Development Team.You’ll find me at following conferen…