8 Bulk Update Methods Compared

articles: 

Comments

I find this a very good article and I would like to explore some of the results of the tests. Can you provide the code use for the tests? For example, when I try to replicate method 8, the function won't compile because return value (test_num_arr) is not defined. I'm a little unclear what this is and how I should define it.

Thanks,
Jesse

I don't have the original code, but TEST_NUM_ARR is just a Nested Table of integers

CREATE OR REPLACE TYPE test_num_arr AS TABLE OF INTEGER;

Should do the trick, I think.