Mittwoch, 3. Februar 2016

PLSQL Profiler Runs 2.0

By now our lonely page looks pretty much empty, so we will add some content by adding and Interactive Report region to the page (Simple drag it in the Content Body section).



For now it is red, showing that there is an error.


Don't worry, we have just not defined the query to feed the report yet. I use this slightly ajusted query from an old post to solve this issue.

SELECT r.runid ,
  r.related_run ,
  r.run_owner ,
  TO_TIMESTAMP(TO_CHAR(r.run_date, 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS') AS run_date ,
  r.run_comment ,
  r.run_total_time ,
  r.run_comment1
FROM plsql_profiler_runs_vw r;

And the result looks imediatly like this:



Hmm, looks like I was a little sloppy on adjusting the Timestamp formats. After some adjustments in Shared Components/Edit Globalization Attributes/Globalization the outcome should be like this:


Keine Kommentare:

Kommentar veröffentlichen