Column List Hanlder
If I am defining a Column list handler, do the cols(#) have to be the correct column number or is this just an identifier? For example, see below. Is it ok if max_salary is really in column 10 in the table?
DECLARE
cols DBMS_UTILITY.NAME_ARRAY;
BEGIN
cols(1) := 'job_title';
cols(2) := 'min_salary';
cols(3) := 'max_salary';
DECLARE
cols DBMS_UTILITY.NAME_ARRAY;
BEGIN
cols(1) := 'job_title';
cols(2) := 'min_salary';
cols(3) := 'max_salary';
0