1. Usage of Named and mixed notation with PL/SQL subprograms in a SQL statement
Prior to 11g, to use a sub-program (e.g. function) in a SELECT statement you have to provide the real parameters in positional notation. Let’s look at an example using both 10g and 11g to understand it better. Here is a small piece of code which calculates the years of employment of an employee :-
CREATE OR REPLACE FUNCTION cal_employment_duration (
Oracle has release the 3rd critical patch update for 2008 (CPU July 2008). Critical patch updates mostly contain fixes to security vulnerabilities plus it would have non-security fixes too. This critical patch update contains 45 new security fixes across all products which includes14 for Oracle database. Please review the following URL to see if the product you are using requires this patch or not.
Also refer to Metalink note id 579278.1 for Oracle database and Fusion middleware products.
The next critical patch update (CPU) would be coming in October 2008.
I was going through the enhancements made for PL/SQL in Oracle 11g and learn that there are quite a few. I am going to post on these new features in two parts. Here goes the first part.
1. Usage of sequences in PL/SQL expressions
Allows you to assign a sequence value in an expression that is, you do not need to use a SQL query to generate sequence value and assign it to variable. Here is an example :-
SELECT seq_name.nextval INTO variable FROM dual; –> this was how we used to generate sequence values inside PL/SQL
From 11g (more...)
Hats off to its organizers!!!
24th May 2008 9:30 am IST
5th Floor, Eros Towers
Nehru Place, New Delhi
More details at http://www.barcamp.org/BlogCampDelhi