On the internet a lot is to be found about linebreaks in APEX. I thought it could be useful to put yet another description of how to show linebreaks in interactive reports, if only for my own archive ;-).

On a log-table data  I want to show an interactive report to show the technical process made elsewhere (through a procedure, not described here) and it's results.

The logtable I use is built as follows:
  CREATE TABLE LOG_TABLE 
   (  "LOGDATE" TIMESTAMP (6) WITH TIME ZONE, -- detailed time
  "LOG_LOCATION" VARCHAR2(200), -- place in pl/sql where log is performed
  "MELDING" VARCHAR2(4000) --report
   ) ;
The source for my interactive report starts as:
SELECT LOGDATE
 ,LOG_LOCATION
 ,MELDING
FROM LOG_TABLE;
I created an interactive report that looks like this:



All text from "MELDING" is shown on one line, which is not desirable for comprehensive reading.

My first attempt to change the one-line-behaviour is as follows:
SELECT LOGDATE
 ,LOG_LOCATION
 ,replace(MELDING, chr(10), '<br>') melding
FROM LOG_TABLE;
Unfortunately, this is not enough for APEX.
The next step is necessary to show linebreaks in the interactive report:
make the column "MELDING" a Standard Report Column



It will now show the linebreaks as wanted in the interactive report, which should help to develop (and debug) a little faster.