Main menu:

Site search

Categories

Tags

intern

Oracle und SQL

Perl

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 table of varchar2(50); a1_emp t_emp := t_emp(); […]