Being a huge fan of Logger, the PL/SQL logging utility, I really wanted this be to included in the project that I'm currently working on. So I downloaded it (link at the bottom of this blog) and included it in our deployment scripts. Done.... at least I thought so, but of course this wasn't the case.
The regular install script for Logger looks something like the following (parts removed and table names are changed):
A few weeks ago Packt Publishing asked me if I would give a book review for the recently released Oracle APEX Cookbook, the second edition by Marcel van der Plas and Michel van Zoest. In exchange I would get the e-book for free, so this can be considered a sponsored blogpost. Even though it is sponsored I will give my honest opinion about it.
The book contains fifteen chapters starting with "Creating a Basic APEX (more...)
On one of the pages there was a need to refresh a report region when a node in an APEX Tree was clicked. As far as I know there is no built-in method to create a Dynamic Action to a node in an APEX Tree, so this might call for a Custom Event.
If there is a built-in method, please leave a comment :)
Trigger Custom Event
To trigger a Custom Event, change the "link" (more...)
Yesterday I attended John King (@royaltwit) session on Oracle 12c for developers. He gave an overview of all the goodies that are available to us as developers. The whole plugging and unplugging of database, though very cool and exiting, is most likely not very relevant to most developers.
When he (more...)
Representing hierarchical data in an APEX Tree is fairly straight forward, the wizard to create a tree region assists you with that. But when you need to show data from multiple tables, you will need to provide your own query. In a previous blogpost I have written how to achieve (more...)
The PIVOT and UNPIVOT operators were introduced in Oracle 11g and the other day I helped out a friend using these operators.
He wanted the data in the columns to be "shifted to the left". To explain a little more, take a look at the following data:
ID V1 V2 (more...)
In two previous blogposts I described a method to transform a regular APEX Tree component to a Tree component with checkboxes. The second blogpost described a way to retrieve the data from the database using JSON and AJAX and check the appropriate checkboxes. In this last part of the series (more...)
One of the big announcements of Oracle Open World 2013 is the Oracle Database In-Memory option. By simply "flipping the switch" the application will run faster than ever before.
From my understanding flipping the switch is making changes to some (not sure which) initialisation parameters.
What is the (more...)
After you have modified the standard APEX tree to a tree with checkboxes (see this blogpost
) you will probably need to find a way to load data from the database and show the values previously checked by the user.
In this blogpost I will show you how to load (more...)
The APEX Tree component is based on jsTree
which is a jQuery Tree Plugin. However not all functionality is implemented in APEX. Knowing the component on which it is based, we can find the documentation and enhance the Tree in APEX. One of these enhancements is to have checkboxes in (more...)
When you have a table with a hierarchical relation it is very easy to create a Tree component in APEX. Simply write the hierarchical query using START WITH and CONNECT BY and you're good to go. When you have a Master-Detail relation between two tables, and you want to show (more...)
Personally I don't like reading documentation from my computer, I prefer to have a "real" book. So when Oracle 12c came out I wanted to read the New Features guide and the Concepts guide again, but the fact that I would have to read it off my computer screen stopped (more...)
In your APEX application, you can define several default format mask to be used throughout the application, such as the Application Date Format or the Application Date Time Format. This eliminates the need to specify the format mask for each Date Picker item that you use. It helps in keeping the application at least consistent regarding the format mask used.
When you want to do some validation in your forms using the Dates entered by the enduser, you might have a need for the Application Date Format.So instead of hard coding (using the same format mask as you entered):
Yesterday I wrote a blog on how you can highlight a record in a report. That blogpost can be found here.
Learco Brizzi posted a comment on a different way of accomplishing the same thing
. And there are probably a number of other possibilities to implement the same requirement.In this blogpost I want to show you how to do the same with a Dynamic Action. Why would you want to choose for a Dynamic Action? This is a more efficient way because you don't need to refresh the page or the region.
This blogpost will use a report based (more...)
Yesterday I read a question which was posted as a reply to an earlier blogpost.
The orginal blogpost was about how to make a Report Row clickable, instead of just the Edit column.The question was: "How do I keep the clicked row highlighted so I can keep it as context information?"To see a working example of the requirement, check out this sample page
In this blogpost I will provide a step-by-step way of doing just that.
For this to work properly, you will need a page with a report. In this blogpost page 9 will contain a (more...)
a number of years ago.
Want to take a look at a demo first before the steps to take to make it work? It's right here
For this example, I will use a simple table named TASKS:
create table TASKS
Can't believe it's almost two weeks ago. Together with Mark Rittman
, Carl Dudley
, Sten Vesterli
, and Tanel Poder
, I was invited to join in for the ACED Nordic Tour.During the Nordic Tour we visited Denmark, Sweden, Norway and Finland. Four countries in four days.I knew it was going to be a busy week, but didn't expect to be exhausted when I got back home on Saturday.On Monday I flew into Copenhagen, Denmark where I met up with Sten Vesterli and Ken Holmstykke Jensen from the Danish Oracle User Group
. They were kind enough (more...)
Yesterday evening we had the annual "We went to OOW and this is what's new in the world we call Oracle" at AMIS. Starting around 5pm and ending around 10pm a lot of information was presented by several AMIS colleagues.My contribution to the evening was (amongst others) a little bit of new features in SQL and PL/SQL, only a little bit as there is too much to cover in just 20 minutes. It's the little things that make me happy. What is the little thing that I like?When you define a table you can assign a default value (more...)
One of things I don't like about Oracle SQL Developer is that if you are browsing and clicking on tables, it can automatically open the table on the right side of the IDE.There is a simple way to switch that off, just heard how to switch this feature off. Navigate to the Preferences settings:
Goto Database >> Objectviewer, and uncheck the tickbox labelled "Open Object on Single Click"
And that's it.
Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called "PL/SQL Enhancements brought by the latest generation of database technology". The room was packed. For the upcoming release of the Oracle 12c database the enhancements were broken into three areas: