Ever wanted to see Tom Kyte and Tom DeMarco live on stage? That’s your opportunity to see both at one event! Check out the details at the conference page of the Austrian Oracle Usergroup. And the best news is that it’s free! See you there.
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
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 have already blogged about it in Caution when using PL/SQL functions in a SQL statement, but that was in the context of writing a stand alone SQL statement for a report, … but what actually happens if you have a SQL embedded into PL/SQL like the following example procedure code in a package
PROCEDURE processEmps ( pDepartmentId IN NUMBER ) IS BEGIN FOR rEMP IN ( SELECT EMPLOYEE_ID FROM EMPLOYEES WHERE SALARY > getAvgDeptSalary(pDepartmentId) ) LOOP NULL; END LOOP; END processEmps;
(Note: getAvgDeptSalary isn’t a very good example, because you could also do that with SQL only, but it’s just an example)
Very simple. A function in the WHERE clause which uses the procedure parameter pDepartmentId. What would you expect how the code/SQL is executed?
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.
Check out the new “I love PL/SQL, and …” web-site and help to improve PL/SQL!
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.
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 is it all about?
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.
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 release 1.2 has some interesting features, especially for Oracle APEX developers.
- Direct Export/Import of an Oracle APEX application has been integrated into the new release. It also offers several reports to browse the Oracle APEX Dictionary views. See Kris Rice blog postings New Patch with APEX features and More APEX/SQL Developer for more details.
- The Oracle Migration Workbench has been integrated into SQL Developer. You can read more about it at Donal Daly’s blog in his Oracle Database Migration has reached the next level posting.
Give it a try and check it out.