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(); […]
Posted: November 8th, 2009 under Oracle, PLSQL, SQL Beispiele.
Comments: none