Archive for juni, 2012

Show table comments in SQL developer

My default development client is the Oracle SQL Developer. If I compare it with TOAD it is slim, free to use and includes a table modeling area. One thing I don't like is the ability to see table comments. To

Read More

Select into statements..

One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table into local variables. The problem is that the data may or may not exist (i.e. return 0..1 rows). They're several

Read More

Upgrading GlassFish 3.1.1 to 3.1.2 on Oracle Linux 6.2 64-bit

  Posted on 06-JUN-2012 11:39 by matthiashoys Environment: GlassFish 3.1.1 Open Source Edition (Web Profile), Oracle Linux 6.2 64-bit, Application Express 4.1.1 There are 3 ways to upgrade GlassFish v3.1.1 to v3.1.2: by using the graphical Update Tool, by using

Read More

The function for APEX Interactive Reports

The gReport.searchfunction is used internally by Interactive Reports when a filter is applied on the report. Even if the function is not documented by Oracle, taking a look at the source code for the Interactive Report Search Field gives

Read More

NTH Value windowing

In my previous post which highlighted some analytic functions, I mentioned that the windowing clause must be explicitly defined when using the NTH_VALUE function. To recap, here's the example I used for NTH_VALUE which lists the 2nd highest salary for

Read More