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
gf_update_tool

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 gReport.search 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 gReport.search 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