PL/SQL: Clearing a Collection

From: rios <rios_at_rios.com>
Date: Sat, 30 Dec 2006 03:35:10 -0500
Message-ID: <12pc9605eu1gb2b@corp.supernews.com>

10gR2

Is assigning NULL to Nested Table (to clear it) documented syntax ? or should it be the_nested_table_variable.DELETE ?

DECLARE
    TYPE typ_emp_table IS TABLE OF scott.emp%ROWTYPE;     l_emp_table typ_emp_table ;
BEGIN
    select * BULK COLLECT INTO l_emp_table FROM scott.emp;

• l_emp_table.DELETE; or l_emp_table := NULL; END ;

thanks Received on Sat Dec 30 2006 - 02:35:10 CST