Archive for 'PLSQL'
New Feature for collections in Oracle 11
Starting with Oracle 11 it is now possible to use set operators on “some” collection types (ie varrays and nested tables, NOT index by Tables).
A simple example:
PROCEDURE COLL_SET_OP
IS
cursor c_emp(c_p_salary number) is
select first_name, last_name, salary from employees
where salary > c_p_salary;
type t_emp is [...]
Posted: November 8th, 2009 under Oracle, PLSQL, SQL Beispiele.
Comments: none