/images/avatar2.png

micodify

Arraylike Functions in PL/SQL

Some time ago, when I had to take care of Oracle Forms, I was annoyed that in Forms you always have to call several procedures for switching on and off. So you have to drop the following lines to show a text field again.

RESTful Deployment

I have been an enthusiastic APEX fan for years. And like every APEX fan, I also have a workspace on APEX. https://apex.oracle.com. Here Oracle offers the possibility to get to know APEX and to host small demo projects. You can switch and manage within your workspace as you like. What Oracle does not offer here, however, is external access to the database / schema with an IDE or SQLPlus. Of course, otherwise Oracle would have to publish the port of the DB listener.

Interactive Grid – Update current row only

In my current project I use an interactive grid on one page. When you click on a row, i. e. select it, a report is displayed below the grid that displays this data set. The editing of the data set is realized in a modal dialog. If it is closed, the report including the currently selected line in the grid should be updated.