Oracle Virtualization and Cloud Consulting
view counter

APEX Feed

Oracle Application Express (APEX) resources, news, and support articles.

Application Express 4.0 Early Adopter Phase II is available

The second phase of the Application Express 4.0 Early Adopter is now available. A new instance with the latest build of Application Express 4.0 is now available on http://tryapexnow.com.

Application Express 4.0 Early Adopter Phase II (EA2) Available

The Application Express 4.0 Early Adopter Phase II (EA2) is now available. Like EA1, this instance is running on Amazon EC2. The beauty of Amazon's elastic IP feature is that we could work on the EA2 instance and get it completely ready, then associate the elastic IP with the new instance, making the switch in less than 60 seconds.

APEX 4.0 EA2 (with Websheets) very very close...

The APEX Development likes to hint and build up our expectations ;-)

APEX Listener EA2 with native Excel Upload

Kris Rice blogged about the new version of the APEX Listener here and here. The APEX Listener will become the preferred way of connecting to APEX (before Apache and the Embedded PL/SQL Gateway). If you are not familiar with the APEX Listener, you find more information here.

Get me a Suite at ODTUG!

If you are going to ODTUG this year and you want me to do a favor...

SOUG: SQL Developer with Syme Kutz

Tonight was the Suncoast Oracle User Group (SOUG) meeting with Syme (pronounced Sim-e, I thought it was Si-me) Kutz of Oracle presenting on SQL Developer, mainly the new Unit Testing functionality.

APEX Refresh Classic Report Region AJAX style

We often have the need to refresh a classic report region, AJAX style. It is straightforward to get a refresh link on the page. I used to just build a link using $a_report (the APEX built-in for doing partial page refresh on classic reports). But I have found it is better to create a javascript function in the region header or footer. This has the advantage that you can call it from a button on the page, or from any location on the page, not just from within the header or footer itself. If you put the following

<script type="text/javascript">

Views and Order By

Developers like views…they can simplify things and hide (protect us from) underlying complexity.
For example, would you rather write the query -

SELECT
ename,
department_name
FROM
emp_vw

or

SELECT
e.ename,
d.dname
FROM
emp e,
dept d
WHERE
e.deptno = d.deptno;

It’s a rhetorical question so please don’t say “I prefer the second”…otherwise there’s no point [...]

Branches with Conditions When Button Pressed - be careful

Consider this example; we have a typical APEX Report with Form.

OBIEE: Create Repository Init Block

My post earlier today, OBIEE: Text File as Data Source , was the first part of my overall goal.

view counter