Inside Oracle APEX by Patrick Wolf

Oracle 11gR2 available for download!

Oracle 11gR2 has just been made available for download. The first operating system which runs the new release is Linux x86 and x86-64. Other operating systems will follow. Get the details about what’s new in 11gR2

Continue reading...

SQL embedded into PL/SQL

A few days ago I spoke with another developer about SQL embedded into PL/SQL code and how function calls are handled in the WHERE clause of SQL statements. There is sometimes confusion who (PL/SQL engine or SQL engine) is executing it, I thought it’s a good idea to write a posting about it. Last year I [...]

Continue reading...

What is the foundation of Oracle Application Express (APEX)?

You are correct, it’s PL/SQL! I’m sure you knew that So that means every improvement which is done for PL/SQL is good for us Oracle APEX developers, like the function result cache, the continue statement and much more which have been introduced in Oracle 11g. Did you know that there is a new initiative by [...]

Continue reading...

Oracle 11g available for download!

Good news! Oracle 11g is finally available for download! Ok, until now it’s just available for Linux, but I’m sure other platforms will follow soon. For those who can’t install it yet, at least you can have a look at the Oracle 11g documentation and the New features section in the documentation. Have fun!

Continue reading...

Oracle 11g: Native Web Services

Just stumbled across an interesting paragraph in the New Features in Oracle XML DB for Oracle Database 11g Release 1 about Database Native Web Services. The feature didn’t get that much attention yet on the Oracle 11g related blog postings, but according to the description it’s a real nice improvement compared to the 10g solution. So what [...]

Continue reading...

Oracle 11g some more infos

Just noticed that Oracle has put some more information about Oracle 11g onto OTN. There are a lot of whitepapers available on OTN. For example the Oracle Database 11g New Features Overview which even mentions Oracle APEX! Ok, they mention it on the last page, but at least! Another interesting read is Oracle Database 11g [...]

Continue reading...

Oracle Database Plugin for Eclipse

Looks like Oracle is contributing more and more for the Eclipse environment. A few weeks ago they joined the Eclipse Foundation and today I read on Donal Daly’s blog that Oracle has released a beta version of the Oracle Database Plugin for Eclipse Data Tools Platform. For more details see the posting on Donal’s blog.

Continue reading...

Oracle SQL Developer 1.2 released

Maybe you have already read somewhere else that Oracle SQL Developer 1.2 has been released. Maybe you have also read in one of my previous postings that PL/SQL Developer is my favorite development IDE. But why could SQL Developer still be interesting if you are an Oracle APEX developer and are using another IDE? Because the new [...]

Continue reading...

Oracle Database 11g will be launched on July 11

Just read on Edie Awad’s blog, that the Oracle Database 11g is going to be launched on July 11 with an event in New York City.

Continue reading...

The mystery of Outer Joins

From my long time experience with Oracle, I noticed that a lot of people have problems with Outer Joins. Especially if the Outer Join also contains an additional restriction on the outer join table.

Continue reading...