Thursday, October 4, 2012

What version do I have?

What if you quickly want to see what APEX version you're running...
Just login as system and use the following query:

select comp_name, version from dba_registry;

Not only the APEX version is show but also other version information of the database.

Monday, October 1, 2012

Interactive Report 100% width

Did you know that you can make an interactive report fill up all horizontal space on the page very easily? You can do this by adding the following code to the HTML header section of the page:

<style type="text/css">
  .apexir_TOOLBAR_OPEN {width:100%;}
  #apexir_TOOLBAR {width:100%;}
  #apexir_DATA_PANEL table,
  .apexir_WORKSHEET_DATA {width:100%;}

If you set your report template to 'Borderless Region' it should work immediate.