If you didn’t already see the news, the EA2 release of APEX4.0 has just been opened up.
Head over to www.tryapexnow.com, sign up for a workspace and try out all the cool new features.
EA2 includes the following key features -
Websheets (this will be huge!)
New collection enhancements
Tree region
Debugging has been rewritten
and many more (see [...]
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 [...]
I’d love to say “I’m quite often asked…”, but to be honest hardly anyone seems to use Collections in APEX (a very under utilised feature in my opinion).
However, a question does come up from time to time, often along the lines of “I am using a collection but it is slow…”.
Typically, you might create a [...]